Page 1 of 1
problem with Stored Procedure in datastage
Posted: Tue Mar 18, 2008 5:45 am
by chvenkat.v
pls tell me problem with server or my code.
in datastage, oracle entr. stage. we can call stored procedure or not.
if yes pls tell me . if no then in stored procedure stage how can i get output result to a dataset.
pls tell me
thanks
venkat
Code: Select all
SQL> CREATE OR REPLACE PROCEDURE TEST1( INDATE IN DATE)
2 IS
3 BEGIN
4 SELECT COUNT(*) FROM IP WHERE EFF_DT=TO_DATE(INDATE, 'YYYY-MM-DD');
5 END;
6 /
Warning: Procedure created with compilation errors.
SQL> EXECUTE TEST1
BEGIN TEST1; END;
*
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00905: object BDWUSER.TEST1 is invalid
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
Posted: Tue Mar 18, 2008 6:20 am
by niharranjan
Hi,
i could not find the answer... Can anyone tell me the answer..
Many thanks in advance.
nihar
Posted: Tue Mar 18, 2008 7:47 am
by chulett
The procedure didn't compile. What else are you expecting to be told?
Posted: Tue Mar 18, 2008 3:26 pm
by ray.wurlod
Should IS (line #2) be AS ?
Posted: Tue Mar 18, 2008 3:32 pm
by chulett
Nope. For a procedure it would be 'IS', a table or view - 'AS'.
Posted: Tue Mar 18, 2008 3:36 pm
by ray.wurlod
I defer to your Oracle knowledge. It's not my forte.
Re: problem with Stored Procedure in datastage
Posted: Tue Mar 18, 2008 10:44 pm
by chvenkat.v
Sorry ray, I forget to post my executed procedure any way it is working fine.
My problem is here any possible to call procedure in oracle ent. stage.