Mats Stromberg schrieb:
> I've seen such errors go away when replacing
>
> { ? = call is_authorized(?,?) }
> to Oracle Styled ones
> begin ? = call is_authorized(?,?) end;
How can I modify the SQL request? Anything, I have, is:
<cfstoredproc procedure="is_authorized" datasource="#Application.DSN#"
returncode="yes">
<cfprocparam type="in" cfsqltype="cf_sql_varchar" dbvarname="fp_user"
value="#session.username#">
<cfprocparam type="in" cfsqltype="cf_sql_varchar"
dbvarname="fp_procedure" value="READ_ALTDAT_MENUE">
</cfstoredproc>
Today our database administrator was in office, so we could have a
closer look at the is_authorized function. We did a few tries directly
on the database and the function seems to be OK.
> What release is your target DB?
11.2.0.3.0
> I've had some problems with the "old"
> ojdbc14.jar on 11gR2 so I usually replace it with the ojdbc6.jar
> (rename the old ojdbc14.jar to something like ojdbc14.jar.org
> and the restart your OpenBD
Did so and with the new driver the NullPointerException is gone but the
ORA00900-Error is still there...
Is it possible to see the SQL statement, OpenBD tries to send to the
Oracle database?
Yours
Manuel
--
--
online documentation: http://openbd.org/manual/
http://groups.google.com/group/openbd?hl=en
---
You received this message because you are subscribed to the Google Groups "Open
BlueDragon" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/groups/opt_out.
