Getting Error ORA-923 in oracle query execution
Hi , I am getting error ORA -923 (from missing from statement) when i am tring to execute a sql query from Javascript file. Here i am successfully able to connect & execute queries with MYSQL. But in oracle connection i am getting this error even i can successfully make a connection with oracle. with isql & a program written in C i can connect and execute queries ok. I am using FreeSwitch 1.0.6 unixOdbc 2.3.0 Please tell me where is problem. Best Regards, Rajesh Bansal
Sounds like a SQL syntax error - can you show us the code that's executing the statement that gives the error? Specifically Oracle is complaining about not finding FROM where it expects to in the SELECT. -Steve On 7 January 2011 15:15, Rajesh Bansal <bansal.rajeshkr@gmail.com> wrote:
Hi , I am getting error ORA -923 (from missing from statement) when i am tring to execute a sql query from Javascript file. Here i am successfully able to connect & execute queries with MYSQL. But in oracle connection i am getting this error even i can successfully make a connection with oracle. with isql & a program written in C i can connect and execute queries ok. I am using FreeSwitch 1.0.6 unixOdbc 2.3.0 Please tell me where is problem. Best Regards, Rajesh Bansal
_______________________________________________ FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
Hi Steve, I am using following sample code. use("ODBC"); var dsn = "rajesh_dsn"; var db_user = "avc"; var db_pass = "avc"; var db = new ODBC(dsn, db_user, db_pass); var sql = "select sysdate from dual"; console_log("info","\nbefore connect with DB\n"); if(db.connect()) { if(session.ready()) session.answer(); console_log("info","\n\nafter connect with DB\n"); if (db.exec(sql)) session.hangup(); //might want to say something nice instead. else console_log("info","\n\nconnect with DB\n"); while (db.nextRow()) { row = db.getData(); console_log("info", "UserName: " ); }} else console_log("info","\n\nunable to connect with DB\n"); Best Regards, Rajesh Bansal On Fri, Jan 7, 2011 at 11:35 PM, Steven Ayre <steveayre@gmail.com> wrote:
Sounds like a SQL syntax error - can you show us the code that's executing the statement that gives the error?
Specifically Oracle is complaining about not finding FROM where it expects to in the SELECT.
-Steve
On 7 January 2011 15:15, Rajesh Bansal <bansal.rajeshkr@gmail.com> wrote:
Hi , I am getting error ORA -923 (from missing from statement) when i am tring to execute a sql query from Javascript file. Here i am successfully able to connect & execute queries with MYSQL. But in oracle connection i am getting this error even i can successfully make a connection with oracle. with isql & a program written in C i can connect and execute queries ok. I am using FreeSwitch 1.0.6 unixOdbc 2.3.0 Please tell me where is problem. Best Regards, Rajesh Bansal
_______________________________________________ FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
_______________________________________________ FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
Hi All, I have find reason of problem with UnixOdbc (with Oracle). When we are using freeswitch with ODBC support before executing a sql query it run a test query "Select 1" which works at MYSQL but didn't work at ORACLE. This change should be in switch_odbc.c file. Please someone raise it as a minor bug so that it can be fixed in next releases. Best Regards, Rajesh Bansal On Mon, Jan 10, 2011 at 1:39 PM, Rajesh Bansal <bansal.rajeshkr@gmail.com>wrote:
Hi Steve,
I am using following sample code.
use("ODBC");
var dsn = "rajesh_dsn"; var db_user = "avc"; var db_pass = "avc"; var db = new ODBC(dsn, db_user, db_pass); var sql = "select sysdate from dual";
console_log("info","\nbefore connect with DB\n");
if(db.connect()) { if(session.ready()) session.answer(); console_log("info","\n\nafter connect with DB\n");
if (db.exec(sql)) session.hangup(); //might want to say something nice instead. else console_log("info","\n\nconnect with DB\n"); while (db.nextRow()) { row = db.getData(); console_log("info", "UserName: " ); }} else
console_log("info","\n\nunable to connect with DB\n");
Best Regards, Rajesh Bansal
On Fri, Jan 7, 2011 at 11:35 PM, Steven Ayre <steveayre@gmail.com> wrote:
Sounds like a SQL syntax error - can you show us the code that's executing the statement that gives the error?
Specifically Oracle is complaining about not finding FROM where it expects to in the SELECT.
-Steve
On 7 January 2011 15:15, Rajesh Bansal <bansal.rajeshkr@gmail.com> wrote:
Hi , I am getting error ORA -923 (from missing from statement) when i am tring to execute a sql query from Javascript file. Here i am successfully able to connect & execute queries with MYSQL. But in oracle connection i am getting this error even i can successfully make a connection with oracle. with isql & a program written in C i can connect and execute queries ok. I am using FreeSwitch 1.0.6 unixOdbc 2.3.0 Please tell me where is problem. Best Regards, Rajesh Bansal
_______________________________________________ FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE: http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
_______________________________________________ FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
Someone should raise it as a minor bug with Oracle. :( They are the only modern db that I know of that requires a hack of "FROM dual" on the SQL. I suppose either a) switch_odbc can auto detect oracle (not easy, it would have to carry state in the dbh I guess) or b) a setting (again, probably on the dbh) that you can put in FS's config to tell FS not to do the select 1. Either one is... umm.. yuck. :( On Mon, Jan 10, 2011 at 5:39 AM, Rajesh Bansal <bansal.rajeshkr@gmail.com> wrote:
Hi All, I have find reason of problem with UnixOdbc (with Oracle). When we are using freeswitch with ODBC support before executing a sql query it run a test query "Select 1" which works at MYSQL but didn't work at ORACLE. This change should be in switch_odbc.c file. Please someone raise it as a minor bug so that it can be fixed in next releases. Best Regards, Rajesh Bansal
On Mon, Jan 10, 2011 at 1:39 PM, Rajesh Bansal <bansal.rajeshkr@gmail.com> wrote:
Hi Steve, I am using following sample code. use("ODBC"); var dsn = "rajesh_dsn"; var db_user = "avc"; var db_pass = "avc"; var db = new ODBC(dsn, db_user, db_pass); var sql = "select sysdate from dual"; console_log("info","\nbefore connect with DB\n"); if(db.connect()) { if(session.ready()) session.answer(); console_log("info","\n\nafter connect with DB\n"); if (db.exec(sql)) session.hangup(); //might want to say something nice instead. else console_log("info","\n\nconnect with DB\n"); while (db.nextRow()) { row = db.getData(); console_log("info", "UserName: " ); }} else console_log("info","\n\nunable to connect with DB\n"); Best Regards, Rajesh Bansal
On Fri, Jan 7, 2011 at 11:35 PM, Steven Ayre <steveayre@gmail.com> wrote:
Sounds like a SQL syntax error - can you show us the code that's executing the statement that gives the error?
Specifically Oracle is complaining about not finding FROM where it expects to in the SELECT.
-Steve
On 7 January 2011 15:15, Rajesh Bansal <bansal.rajeshkr@gmail.com> wrote:
Hi , I am getting error ORA -923 (from missing from statement) when i am tring to execute a sql query from Javascript file. Here i am successfully able to connect & execute queries with MYSQL. But in oracle connection i am getting this error even i can successfully make a connection with oracle. with isql & a program written in C i can connect and execute queries ok. I am using FreeSwitch 1.0.6 unixOdbc 2.3.0 Please tell me where is problem. Best Regards, Rajesh Bansal
_______________________________________________ FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
_______________________________________________ FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
_______________________________________________ FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
-- -Rupa
We already have a similar autodetect for firebird there though, so probably no more yuck than it already is. -Steve On 10 January 2011 17:18, Rupa Schomaker <rupa@rupa.com> wrote:
Someone should raise it as a minor bug with Oracle. :( They are the only modern db that I know of that requires a hack of "FROM dual" on the SQL.
I suppose either a) switch_odbc can auto detect oracle (not easy, it would have to carry state in the dbh I guess) or b) a setting (again, probably on the dbh) that you can put in FS's config to tell FS not to do the select 1.
Either one is... umm.. yuck. :(
On Mon, Jan 10, 2011 at 5:39 AM, Rajesh Bansal <bansal.rajeshkr@gmail.com> wrote:
Hi All, I have find reason of problem with UnixOdbc (with Oracle). When we are using freeswitch with ODBC support before executing a sql query it run a test query "Select 1" which works at MYSQL but didn't work at ORACLE. This change should be in switch_odbc.c file. Please someone raise it as a minor bug so that it can be fixed in next releases. Best Regards, Rajesh Bansal
On Mon, Jan 10, 2011 at 1:39 PM, Rajesh Bansal <bansal.rajeshkr@gmail.com> wrote:
Hi Steve, I am using following sample code. use("ODBC"); var dsn = "rajesh_dsn"; var db_user = "avc"; var db_pass = "avc"; var db = new ODBC(dsn, db_user, db_pass); var sql = "select sysdate from dual"; console_log("info","\nbefore connect with DB\n"); if(db.connect()) { if(session.ready()) session.answer(); console_log("info","\n\nafter connect with DB\n"); if (db.exec(sql)) session.hangup(); //might want to say something nice instead. else console_log("info","\n\nconnect with DB\n"); while (db.nextRow()) { row = db.getData(); console_log("info", "UserName: " ); }} else console_log("info","\n\nunable to connect with DB\n"); Best Regards, Rajesh Bansal
On Fri, Jan 7, 2011 at 11:35 PM, Steven Ayre <steveayre@gmail.com> wrote:
Sounds like a SQL syntax error - can you show us the code that's executing the statement that gives the error?
Specifically Oracle is complaining about not finding FROM where it expects to in the SELECT.
-Steve
On 7 January 2011 15:15, Rajesh Bansal <bansal.rajeshkr@gmail.com> wrote:
Hi , I am getting error ORA -923 (from missing from statement) when i am tring to execute a sql query from Javascript file. Here i am successfully able to connect & execute queries with MYSQL. But in oracle connection i am getting this error even i can successfully make a connection with oracle. with isql & a program written in C i can connect and execute queries ok. I am using FreeSwitch 1.0.6 unixOdbc 2.3.0 Please tell me where is problem. Best Regards, Rajesh Bansal
_______________________________________________ FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
_______________________________________________ FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
_______________________________________________ FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
-- -Rupa
_______________________________________________ FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
Quick patch attached, it's not actually tested and we'd need to check what the odbc driver name really looked like. -Steve On 10 January 2011 17:24, Steven Ayre <steveayre@gmail.com> wrote:
We already have a similar autodetect for firebird there though, so probably no more yuck than it already is.
-Steve
On 10 January 2011 17:18, Rupa Schomaker <rupa@rupa.com> wrote:
Someone should raise it as a minor bug with Oracle. :( They are the only modern db that I know of that requires a hack of "FROM dual" on the SQL.
I suppose either a) switch_odbc can auto detect oracle (not easy, it would have to carry state in the dbh I guess) or b) a setting (again, probably on the dbh) that you can put in FS's config to tell FS not to do the select 1.
Either one is... umm.. yuck. :(
On Mon, Jan 10, 2011 at 5:39 AM, Rajesh Bansal <bansal.rajeshkr@gmail.com> wrote:
Hi All, I have find reason of problem with UnixOdbc (with Oracle). When we are using freeswitch with ODBC support before executing a sql query it run a test query "Select 1" which works at MYSQL but didn't work at ORACLE. This change should be in switch_odbc.c file. Please someone raise it as a minor bug so that it can be fixed in next releases. Best Regards, Rajesh Bansal
On Mon, Jan 10, 2011 at 1:39 PM, Rajesh Bansal <bansal.rajeshkr@gmail.com> wrote:
Hi Steve, I am using following sample code. use("ODBC"); var dsn = "rajesh_dsn"; var db_user = "avc"; var db_pass = "avc"; var db = new ODBC(dsn, db_user, db_pass); var sql = "select sysdate from dual"; console_log("info","\nbefore connect with DB\n"); if(db.connect()) { if(session.ready()) session.answer(); console_log("info","\n\nafter connect with DB\n"); if (db.exec(sql)) session.hangup(); //might want to say something nice instead. else console_log("info","\n\nconnect with DB\n"); while (db.nextRow()) { row = db.getData(); console_log("info", "UserName: " ); }} else console_log("info","\n\nunable to connect with DB\n"); Best Regards, Rajesh Bansal
On Fri, Jan 7, 2011 at 11:35 PM, Steven Ayre <steveayre@gmail.com> wrote:
Sounds like a SQL syntax error - can you show us the code that's executing the statement that gives the error?
Specifically Oracle is complaining about not finding FROM where it expects to in the SELECT.
-Steve
On 7 January 2011 15:15, Rajesh Bansal <bansal.rajeshkr@gmail.com> wrote:
Hi , I am getting error ORA -923 (from missing from statement) when i am tring to execute a sql query from Javascript file. Here i am successfully able to connect & execute queries with MYSQL. But in oracle connection i am getting this error even i can successfully make a connection with oracle. with isql & a program written in C i can connect and execute queries ok. I am using FreeSwitch 1.0.6 unixOdbc 2.3.0 Please tell me where is problem. Best Regards, Rajesh Bansal
_______________________________________________ FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
_______________________________________________ FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
_______________________________________________ FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
-- -Rupa
_______________________________________________ FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
participants (3)
-
Rajesh Bansal
-
Rupa Schomaker
-
Steven Ayre