Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Call/Execute Stored Procedure in DB2

I'm new to SQLDeveloper with DB2 (but many many years with Oracle PL/SQL)

I'm trying to call a simple Store Procedure (only an Insert of 1 row for LOG), but I can't call/execute it.

In PL/SQL (oracle) I can use
“Begin PR_LOG; End; ”
or “Execute PR_LOG;”

How can I do this with DB2 Procedure ?
I tried :
CALL PR_LOG;

but I receive the error
“DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=PR_LOG;BEGIN ;RETURN, DRIVER=4.33.31”

Thanks…

Comments
Post Details
Added 19 hours ago
2 comments
18 views