Problem Executing stored Procedure

paddu · Post by **paddu** » Mon Sep 25, 2006 3:47 pm

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

kris007 · Post by **kris007** » Mon Sep 25, 2006 3:57 pm

Try

Code: Select all

Exec smdmadm.CHECK_MISSING_KEY_VALUE()

or

Code: Select all

call smdmadm.CHECK_MISSING_KEY_VALUE()

paddu · Post by **paddu** » Mon Sep 25, 2006 4:09 pm

Hi

call smdmadm.CHECK_MISSING_KEY_VALUE() worked .Thanks :D

How can i Exec two procedures one after the other ? Shall i use semi-colon at the end of the statement?

Thank You Very Much
Paddu

kris007 · Post by **kris007** » Mon Sep 25, 2006 4:16 pm

paddu wrote:
How can i Exec two procedures one after the other ? Shall i use semi-colon at the end of the statement?

Yes. Also a commit command if you want to.

paddu · Post by **paddu** » Mon Sep 25, 2006 4:32 pm

i tried this

CALL smdmadm.CHECK_DIM_NULL_VALUE();

CALL smdmadm.CHECK_MISSING_KEY_VALUE();

looks like first procedure exectued . i could see data popluated in the table but i don't see second one executed.

I got thsi warning again
ORA-00900: invalid SQL statement

Thanks
Paddu

kris007 · Post by **kris007** » Mon Sep 25, 2006 4:42 pm

It should be written like this. Notice the absence of semi-colon in the second statement.

Code: Select all

CALL smdmadm.CHECK_DIM_NULL_VALUE(); 

CALL smdmadm.CHECK_MISSING_KEY_VALUE()

or

Code: Select all

CALL smdmadm.CHECK_DIM_NULL_VALUE(); 
commit;
CALL smdmadm.CHECK_MISSING_KEY_VALUE();
commit

paddu · Post by **paddu** » Mon Sep 25, 2006 4:58 pm

Thank You
Paddu