DSXchange

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