Hi,
I am using oracle enterprise stage as the source to Oracle.
I have to excute a stored procedure before the job run. The stored procedure does not take any argument. I have called that stored procedure in the open command as exec proc1 .
but when i run the job it skips this statement. It does not displays any log about this.
Do i need to do any adjustment to execute the open command.
Thanks,
Problem with Oracle open Command
Moderators: chulett, rschirm, roy
Problem with Oracle open Command
Birendra
Re: Problem with Oracle open Command
yes u need to give arguments to the procedure, let it be dummy.
Also it won't display logs in the director, the logs pertaining to proc can be viewed by database dba and not through datastage.
Also it won't display logs in the director, the logs pertaining to proc can be viewed by database dba and not through datastage.
bkumar103 wrote:Hi,
I am using oracle enterprise stage as the source to Oracle.
I have to excute a stored procedure before the job run. The stored procedure does not take any argument. I have called that stored procedure in the open command as exec proc1 .
but when i run the job it skips this statement. It does not displays any log about this.
Do i need to do any adjustment to execute the open command.
Thanks,
Pranay
Seatte, WA
Seatte, WA
Hi,
The stored proc runs fine if i run in the database.
now i have called the stored proc from the open command as you have mentioned using the PL/SQL block
Begin
proc1(1);
end;
Actually the stored proc creates a vies selecting from multiple table.
where can i see, did datastage executed the open statement or not.
Thanks,
The stored proc runs fine if i run in the database.
now i have called the stored proc from the open command as you have mentioned using the PL/SQL block
Begin
proc1(1);
end;
Actually the stored proc creates a vies selecting from multiple table.
where can i see, did datastage executed the open statement or not.
Thanks,
Birendra
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
In the job log you can see that DataStage submitted the Open command to the database server. Whether or not it got executed there is outside of DataStage's control, if the command to execute the stored procedure was correct.
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.
The director log even doest not display the details whether the open command is submitted or not. The stored proc creates a view. The query extarcts the data from the created view. The first error statement in the log says that "table or view does not exist". The view should be created by the stored proc. Do i need to use any environment varible to get the details.In the job log you can see that DataStage submitted the Open command to the database server. Whether or not it got executed there is outside of DataStage's control
Thanks,
Birendra