How to run a sql procedure in Proof

Hicham Tahiri

April 07, 2020 21:36

I tried running a procedure using Execute_Sql command : test_proc

begin

message_bus_support_pkg.post_message('PROJECT_SEGMENT_APP','<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<segmentsEvents xmlns="http://era.nih.gov/projp/segmentsEvents-V1.0">
<applId>555555</applId>
<action>APPL_GRANT_NUM_UPDATED</action>
<applClassCode>G</applClassCode>
</segmentsEvents>', '1.0', 'PROJP') ;

commit;
end;

But I get this error:

error occurred during batching: ORA-06550: line 1, column 338:

PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following:

:= . ( % ;

the database version and vendor:

pl/sql developer
version 12.0.7.1837

7 comments

Joseph Hamdan April 08, 2020 22:30

Hi Hicham,

Thanks for posting on our forum. We are still working on debugging this issue and will be posting updates soon.

We appreciate your patience.

Regards,

Subject7 Team

Jonathan Hotz April 08, 2020 22:52

Hi Hicham,

could you please try actions below to solve it and provide us your results?

Try to copy and paste your query line by line from the editor you used before. It can happen that you paste invisible symbols when you copy full text.
Try to use more simple string values to test if your query works.
Try to use space in the end of each line.

Hicham Tahiri April 09, 2020 13:57

I tried that but got the same error. It seems like executing a sql procedure is not working. Can you send a dummy procedure example to try on.

Jonathan Hotz April 09, 2020 18:11

Your query with procedure call looks simple enough. Just one note: Oracle SQL queries should not be finished with semicolon [ ; ].

Oracle SQL Developer removes semicolon in the end of query automatically, but we don't do it. Could you please try to use your query without semicolon in the end?

Hicham Tahiri April 09, 2020 19:06

I am aware of that. I tried removing the semicolon in the end and still got the same error. I tried both Execute_sql & Get_Db_Value command. Both with same error

-1

Rex Feizi April 09, 2020 19:23

I have 2 questions:

1. Does the below stored procedure work on your SQL Developer?

2. If yes, does it work in Subject7?

So are you saying you have tried a simple procedure like:

BEGIN
  
  DBMS_OUTPUT.PUT_LINE('Hello World!');

END

Hicham Tahiri April 09, 2020 19:47

1- the stored proc doesn't work in SQL developer. I have to add ; at the end to make it work.

error: PLS-00103: Encountred the symbol "end-of-file" when expecting one of the following: ; <an identifier> <a double-quoted delimited-identifier>

The symbol ";" was substituted for "end-of-file" to continue.

Same error using Oracle SQL developer. ";" is required at the end.

2- the stored proc doesn't work in Subject7. Also when adding the ; at the end , I get the same mentioned error

Please sign in to leave a comment.