Trapping Oracle error message
Moderators: chulett, rschirm, roy
Trapping Oracle error message
Hi
I want Trap oracle error message in file . I am using oracle enterprise Stage . I am getting sqlcode in reject link but i also want actual oracle error message
Thanks
Sanjay
I want Trap oracle error message in file . I am using oracle enterprise Stage . I am getting sqlcode in reject link but i also want actual oracle error message
Thanks
Sanjay
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Re: Trapping Oracle error message
Did you use generated SQL or user-defined SQL.sanjay wrote:
I want Trap oracle error message in file . I am using oracle enterprise Stage . I am getting sqlcode in reject link but i also want actual oracle error message
Re: Trapping Oracle error message
Hi ray
when i use external filter stage . it giving error External_Filter_113,0: processing failed for input connection 0: exit status = 255.External_Filter_113
Thanks
Dinesh
when i use external filter stage . it giving error External_Filter_113,0: processing failed for input connection 0: exit status = 255.External_Filter_113
Thanks
Dinesh
sri1dhar wrote:Did you use generated SQL or user-defined SQL.sanjay wrote:
I want Trap oracle error message in file . I am using oracle enterprise Stage . I am getting sqlcode in reject link but i also want actual oracle error message
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Hi Ray
input has reject link of oracle stage with sqlcode
properties of External Filter stage
command = oerr
argument = ora sqlcode
output : contains sequential file with rejected records
Thanks
Sanjay
input has reject link of oracle stage with sqlcode
properties of External Filter stage
command = oerr
argument = ora sqlcode
output : contains sequential file with rejected records
Thanks
Sanjay
ray.wurlod wrote:Dinesh? Sanjay?
How did you specify the input to and output from your External Filter stage? ...
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
My bad. External_Filter_113 was the name of your External Filter stage. (Do you really have than many stages in a job?!!) Exit status 255 is fairly meaningless.
Please describe precisely how you set up the External Filter stage - what you mean by "a sequential file" doesn't make much sense. The output link from this stage receives stdout from the command/script specified. You may therefore need to pipe it through tr to strip unwanted '\n' characters.
Please describe precisely how you set up the External Filter stage - what you mean by "a sequential file" doesn't make much sense. The output link from this stage receives stdout from the command/script specified. You may therefore need to pipe it through tr to strip unwanted '\n' characters.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.