Skip to Main Content

SQL & PL/SQL

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!

ORA-01756: quoted string not properly terminated

542526Apr 29 2009 — edited Jan 22 2013
I can't fix this very simple sql which executed well before I tried to wrap it in "EXECUTE IMMEDIATE". Error is as follows (Yes I understand single quotes need to be replaced with double single-quotes, this is why I cut down stored proc body to as simple as below for debugging purpose):

BEGIN IMMEDIATE 'CREATE OR REPLACE PROCEDURE spDeleteAccessToken; END;
Error at line 1
ORA-01756: quoted string not properly terminated
Script Terminated on line 1.

It didn't really help me telling me "line 1 not properly terminated". Procedure as follows.

EXECUTE IMMEDIATE 'CREATE OR REPLACE PROCEDURE spDelete
*(*
OwnerId number,
OwnerClassifier varchar2,
NumTokensDeleted OUT int
*)*
AS
bOwnerSpecified boolean := false;
Begin
NumTokensDeleted := 0;
End;';

Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 19 2013
Added on Apr 29 2009
21 comments
8,934 views