I am trying to execute a store procedure using Oci stage After Sql
as Exec smdmadm.CHECK_MISSING_KEY_VALUE
It give me this error.
ORA-00900: invalid SQL statement
can anyone help me out with this.
Thsi procedure pulls all the table names , column names , count in that particular schema (smdmadm) and loads into a table.
So there are no inputs parameters and no output parameters for this procedure .
All i need to do is just Exec the Stored Procedure.
Any help appreciated
Thanks
Paddu
Problem Executing stored Procedure
Moderators: chulett, rschirm, roy
Try
or
Code: Select all
Exec smdmadm.CHECK_MISSING_KEY_VALUE()
Code: Select all
call smdmadm.CHECK_MISSING_KEY_VALUE()
Kris
Where's the "Any" key?-Homer Simpson
Where's the "Any" key?-Homer Simpson
It should be written like this. Notice the absence of semi-colon in the second statement.
or
Code: Select all
CALL smdmadm.CHECK_DIM_NULL_VALUE();
CALL smdmadm.CHECK_MISSING_KEY_VALUE()
Code: Select all
CALL smdmadm.CHECK_DIM_NULL_VALUE();
commit;
CALL smdmadm.CHECK_MISSING_KEY_VALUE();
commit
Kris
Where's the "Any" key?-Homer Simpson
Where's the "Any" key?-Homer Simpson