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.)
Using an anonymous pl/sql block and running the following:
Select col1 Into wsSQL From t99;
execute immediate wsSQL;
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
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.