CODEWITHSUNDEEP
oracle-databasestored-proceduressquirrel-sql
Suraj
Suraj

Reputation: 417

Squirrel Client Stored Procedure

I am unable to create a stored procedure for an Oracle database using Squirrel Client.

CREATE OR REPLACE PROCEDURE Notify_Ins(
       ID  NUMBER,
       NAME CLOB,
       EMAILID VARCHAR2) as 
begin

  INSERT INTO test2 ("ID", "NAME", "EMAILID") 
  VALUES (ID, NAME,EMAILID);
END;

/

The above is my code and it gives me an error saying "INVALID SQL STATEMENT" Can anyone please help me out?

Upvotes: 2

Views: 5176

Answers (1)

Colin Bell
Colin Bell

Reputation: 371

You need to change the Statement Separator to something else temporarily. In the menu item Session/Session Properties click on the SQL tab and change Statement Separator to GO

Upvotes: 5

Related Questions