If creating a table t99 (col1 varchar2(256)) then going to the Schema browser selecting this new table and entering the following text into col1. (This text must go into a single row.)
Declare
a pls_integer;
Begin
a:= 1;
End;
Using an anonymous pl/sql block and running the following:
Declare
wsSQL varchar2(256);
Begin
Select col1 Into wsSQL From t99;
execute immediate wsSQL;
End;
Get oracle error:-
Error at line 1
ORA-06550: line 1, column 8:
PLS-00103: Encountered the symbol "" when expecting one of the following:
begin function package pragma procedure subtype type use
<an identifier> <a double-quoted delimited-identifier> form
current cursor
ORA-06512: at line 5
When viewing the text two unprintable characters (cr/lf) can be seen, a Hex display show this.
==> Running of the procedure should be possible.
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center