Here is an example of what I am trying to do:
lcSQL = "get_Scheduler_code ( -1, 1002, 'WCH', '02/01/2001', '02/02/2001', 'test - wch - 02/01/01', 'RFS Level' )}"
lcSql = "{? = call " + lcsql + "}"
lnResult = SQLPREPARE(.mnHandle, lcSql)
The SQLPREPARE being used...
I am running a stored procedure using the escape sequence syntax and all seems to be good. But once I introduce a date parameter I get the error -- 'Syntax error or Access Denied'. How do I use the escape sequence format on parameters.
According to the release notes, corrections were made so that Oracle 8.1.6 ODBC driver would handle CLOB's. I have been unsuccessful in getting a CLOB through the ODBC driver to the database. Does anyone have any information on how to do this??
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.