Hello everyone,
I am trying to code an app for Oracle. I read that a LIMIT clause can only be executed in a FETCH from the PL/SQL online guide, and I'm trying to pass the limit into the query from a data nav function. The passing is OK, I just get a "incorrect ending SQL" error when trying to query.
"SELECT WS_STYLE, PROD_LINE FROM MASTER LIMIT
osid, :limid"
Can anyone help with this???
I tried the Oracle9i beta for JDeveloper and all the new BC4J data tags, but nothing beats the simply robust PHP4!
Thanks -- Eric
I am trying to code an app for Oracle. I read that a LIMIT clause can only be executed in a FETCH from the PL/SQL online guide, and I'm trying to pass the limit into the query from a data nav function. The passing is OK, I just get a "incorrect ending SQL" error when trying to query.
"SELECT WS_STYLE, PROD_LINE FROM MASTER LIMIT
osid, :limid"Can anyone help with this???
I tried the Oracle9i beta for JDeveloper and all the new BC4J data tags, but nothing beats the simply robust PHP4!
Thanks -- Eric