![]() ![]() In first example it returned error and in second case it does not because to include single quote(‘) another single quote (‘) is used which is termed as escape character. The ORA-01756: quoted string not correctly terminated issue occurs when one of the surrounding single quotes in the character, string, or date value is. Look at the actual string that has the problem in it. ![]() This stands in contrast to string datatypes which instead store their length at the beginning, and then an array of characters. SP2-0042: unknown command 'THEN' - rest of line ignored. SP2-0734: unknown command beginning 'IF SQLCODE.' - rest of line ignored. SP2-0734: unknown command beginning 'exception. Don't look at the code that concatenates the string. When someone talks about a string being null-terminated, they usually are talking about a C-style string, which is simply an array of characters, followed by a 0-byte at the end, sometimes refered to as \0 or null. ERROR: ORA-01756: quoted string not properly terminated SP2-0734: unknown command beginning 'return SQL.' - rest of line ignored. Look at the string you are giving to Oracle, find the simple and obvious problem that Oracle told you about, and fix it. If one single quote is used, Oracle will interpret it as the ending string delimiter and fail with ORA-1756.Ĭreate or replace procedure my_proc(var in varchar2)as The problem is that there is a quoted string which is not properly terminated. The first single quote is an escape character which signals that a special character is following – here another single quote. If single quote is one of the characters inside the string, then it should be represented by two single quotes (”). In Oracle, single quote is the string delimiter for all string data types. ORA-01756: quoted string not properly terminated Single quote within a string data type like CHAR, VARCHAR2, NVARCHAR etc. declare bkid book.bookcodetype bkauthorName thorfirsttype bkauthorLastName thorlasttype bktitle book.titletype bkpubcode book.publishercodetype. ORA-01756: quoted string not properly terminated Actually the problem with this syntax is you used double quotes instead of single quotes.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |