Hi,
can any one help me?
I am wanted to call a oracle store procedure which dont accept any arguments or return any values.
How do i execute this procedure?
ODBC stage expect out parmeters from the store procedure, but this procedure doesnot return any thing.
Needed urgently please
Shiva
call oracle procedure which dont accept/return values?
Moderators: chulett, rschirm, roy
Re: call oracle procedure which dont accept/return values?
hello you can use Stored_Procedure stage with no input or output. in output by default you will have ProcCode, ProcMess columns.
in syntax tab you mention your procedure name and take procedure_type tab value as Transform.
in syntax tab you mention your procedure name and take procedure_type tab value as Transform.
Re: call oracle procedure which dont accept/return values?
i am using 7.1 Datastage stored_procedure stage is in 7.5sachin1 wrote:hello you can use Stored_Procedure stage with no input or output. in output by default you will have ProcCode, ProcMess columns.
in syntax tab you mention your procedure name and take procedure_type tab value as Transform.
thanks
shiva
Either a Sequence w/Command stage or Batch job using DSExecute API call to sqlplus command line ALWAYS works.
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Are you not familiar with using sqlplus from the command line? Part of what you pass in is the 'connection' information, user/password@instance specifically. If all this is new to you, have a chat with your DBA or someone in your group who does know this stuff so they can work directly with you on this. Note that you may need a script that calls sqlplus not necessarily a direct, command line invocation. Depends on exactly what needs doing.
Get it working outside of DataStage, then you should be able to just 'plug it in' to your job.
Get it working outside of DataStage, then you should be able to just 'plug it in' to your job.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers