ENHANCEMENT request to support passing PL/SQL blocks as SQL statements

[Sumit Sarkar]

Enhance ADO.NET and/or ODBC provider to support PL/SQL code blocks as SQL statements. At present, exceptions are thrown when executing PL/SQL blocks which are by design since they're not standard SQL statements. There are numerous reports that cannot be easily converted; and this feature will be very helpful. PL/SQL block being executed from SSRS report via ADO.NET or ODBC: begin INSERT into QUAD0009.TT_LM_YEAR SELECT 2013 as YR, TO_DATE('1/1/' || TO_CHAR(2013), 'MM/DD/YYYY') AS STRT_DTM, TO_DATE('1/1/' || TO_CHAR(2013 + 1), 'MM/DD/YYYY') AS END_DTM, TO_DATE('1/2/' || TO_CHAR(2013 + 1), 'MM/DD/YYYY') AS END_NEW_YEARS_DAY FROM DUAL; end; select * from QUAD0009.TT_LM_YEAR; Exception: DDTek.Oracle.OracleException was thrown Message: [6550] ORA-06550: line 15, column 17: PLS-00103: Encountered the symbol "SELECT" Stack Trace at DDTek.Oracle.ba.a(bf A_0, b A_1) at DDTek.Oracle.ba.a(String A_0, bf A_1, b A_2, CommandBehavior A_3, Boolean A_4, Int32 A_5) at DDTek.Oracle.OracleCommand.a(CommandBehavior A_0, j A_1) at DDTek.Oracle.OracleCommand.ExecuteReader(CommandBehavior behavior) at DDTek.Oracle.OracleCommand.ExecuteDbDataReader(CommandBehavior behavior) at WhidbeySchemaViewer.WhidbeySchemaViewer.queryButton_Click(Object sender, EventArgs e) DDTek.SQLState: HY000 DDTek.Number: 6550 DDTek.ErrorPosition: 407 DDTek.Oracle.OracleException was thrown Message: [6550] ORA-06550: line 14, column 1: PLS-00103: Encountered the symbol "/" Stack Trace at DDTek.Oracle.ba.a(bf A_0, b A_1) at DDTek.Oracle.ba.a(String A_0, bf A_1, b A_2, CommandBehavior A_3, Boolean A_4, Int32 A_5) at DDTek.Oracle.OracleCommand.a(CommandBehavior A_0, j A_1) at DDTek.Oracle.OracleCommand.ExecuteReader(CommandBehavior behavior) at DDTek.Oracle.OracleCommand.ExecuteDbDataReader(CommandBehavior behavior) at WhidbeySchemaViewer.WhidbeySchemaViewer.queryButton_Click(Object sender, EventArgs e) DDTek.SQLState: HY000 DDTek.Number: 6550 DDTek.ErrorPosition: 390 Note: This request is on behalf of a customer/prospect.

Continue reading...