Home » Open Source » Programming Interfaces » Problem creating package body via JDBC: Non supported SQL92 token (Oracle 9.2.0.4, RHEL 5)
Problem creating package body via JDBC: Non supported SQL92 token [message #432366] Mon, 23 November 2009 18:28 Go to previous message
pchernik
Messages: 2
Registered: November 2009
Junior Member
Hi All,

I'm getting an exception while trying to do a "create package body" from within my Java application.
java.sql.SQLException: Non supported SQL92 token at position: 6805: v_Counter

I'm on Oracle 9.2.0.4, and exactly same "create package body" call works w/o issues from within sqlplus.

I googled a possible solution, to use execute immediate:

String sql =
"DECLARE\n" +
"v_command VARCHAR2(32767);\n" +
"BEGIN\n" +
"v_command := ?;\n" +
"EXECUTE IMMEDIATE v_command;\n" +
"END;";

Statement stat = conn.PrepareStatement(sql);
stat.setString(1, createScript);
stat.executeUpdate();

But the problem is - my create package script is about 100KB...

Any suggestions are appreciated.

Thanks,
-Pavel

[Updated on: Mon, 23 November 2009 21:52]

Report message to a moderator

 
Read Message
Read Message
Read Message
Previous Topic: Nested Tables with JDBC
Next Topic: HS: Oracle / PostgreSQL
Goto Forum:
  


Current Time: Fri Mar 29 08:42:19 CDT 2024