Details
-
Type:
Technical task
-
Status: Open (View Workflow)
-
Priority:
Major
-
Resolution: Unresolved
-
Affects Version/s: 10.3
-
Fix Version/s: None
-
Component/s: Prepared Statements, Stored routines
-
Labels:
Description
Currently dynamic SQL (prepared statements and EXECUTE IMMEDIATE) can be used within stored procedures, but not in stored functions or triggers. Oracle supports dynamic SQL in stored functions. We'll allow dynamic SQL in stored functions at least for sql_mode=ORACLE.