DSXchange

Thanks Ray. But I am trying to retrieve output from a stored proc and it is different from retrieving result set from a select statement. A simple oracle sp: create or replace procedure test1 (id out number) as begin id := 8; end test1; All I am trying to do it to retrieve the output value from call...

Thanks, Ray. I saw some of the posts mentioned using SQLBindCol instead of SQLBindParameter before calling SQLExecDirect, I've tried that, didn't work for me, still nothing returned. [quote="dealiang"]I use Datastage 7.1. I have a simple oracle procedure that takes one input param and retu...

I have a very simple oracle stored proc which prints out a value when executing it. create or replace procedure test1 as begin dbms_output.put_line(8); end test1; when calling the sp in sql*plus, it returns 8, but when calling it in a datastage 7.1 routine: status = SQLExecDirect(odbcStmtEnv, "...

But why the same set of code returns info variable which contains the return value when executing a sql stored proc, not the oracle stored proc. I didn't have to use sqlbindcol to retrieve output from sql sp, the info variable already contains the return value. Anyways, as Ray suggested, I added the...

Hi All: I have a very simple oracle stored proc which prints out a value when executing it. create or replace procedure test1 as begin dbms_output.put_line(8); end test1; when calling the sp in sql*plus, it returns 8, but when calling it in a datastage 7.1 routine: status = SQLExecDirect(odbcStmtEnv...

I use Datastage 7.1. I have a simple oracle procedure that takes one input param and returns one output param. I have a datastage routine calling the procedure then return the output, the procedure successfully executed but I can't get the output value. Any help greatly appreciated! My oracle proced...

Thanks for replies. We use datastage 7.1. Does anyone know the right syntax of calling an oracle procedure from a datastage routine then return a value from the procedure? squote="'" EQU Statement To "Call " :"myProc (":squote:Client_nm:squote:")" status = SQL...

I am new to datastage, we use 7.x. I want to create a routine that execute an Oracle(10g) procedure which inserts a row to a table then returns one value(seq.currval), in sql*plus, I run the code below to execute myProc: DECLARE s number; BEGIN myProc ( 'test', s) ; dbms_output.put_line(s); END; I a...