PL/SQL (MOSC)

MOSC Banner

dbms_utility.exec_ddl_statement errors when executing SQL that works just fine.

edited Sep 26, 2017 4:37PM in PL/SQL (MOSC) 3 commentsAnswered ✓

I'm trying to create a function that will return a timezone that is buried in the xml column (MY_XML_Column) of the table My_Tablename.

When I execute the results of the dbms_output.put_line( v_sql); in the middle of the stored procedure, it works just fine.

But when I try to use dbms_utility.exec_ddl_statement, I get the following errors:

Error report -

ORA-00905: missing keyword

ORA-06512: at "SYS.DBMS_UTILITY", line 574

ORA-06512: at line 17

00905. 00000 -  "missing keyword"

*Cause:   

*Action:

DECLARE

v_timezone_table  varchar2(50):= 'my_tablename';

  v_id  number :=1;

  v_sql varchar2(1000);

   v_output_time_zone varchar2(50);

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center