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
venkatCode: 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
problem with Stored Procedure in datastage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 94
- Joined: Fri Dec 14, 2007 3:22 am
problem with Stored Procedure in datastage
-
- Participant
- Posts: 18
- Joined: Mon Jul 23, 2007 1:32 am
- Location: Singapore
-
- 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:
-
- Participant
- Posts: 94
- Joined: Fri Dec 14, 2007 3:22 am
Re: problem with Stored Procedure in datastage
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.
My problem is here any possible to call procedure in oracle ent. stage.