Oracle pl sql procedure

1

Hello,
There is a way to call a pl sql procedure
With this synthax I’m getting an error.
Please could you please tell me the right way to call this procedure?

thank you.

1 Like
2

I believe for Oracle it should be call instead of exec.

1 Like
3

I would like to add that the CALL command should not be ended with a semicolon:

CALL pack_context.contextid_open(1066)

Otherwise, it will give you the following error: ORA-00911: invalid character

Also, a procedure can be called with an anonymous block:

BEGIN
  pack_context.contextid_open(1066);
END;