RE: Need to call API from Oracle using Lotus Script to update data to Oracle Daniel W Heichel 30.Dec.14 11:40 PM Lotus Notes LC LSX Oracle Applications Connector - All ReleasesWindows
Answering this question is made a little more difficult because you seem to have cut out and replaced the problem lines. (Here, you have re-used in_field_text for a different parameter.) You have the lines pasted for reference up top, but we don't get to see them "in play", nor do we know exactly which line was throwing the error. The full stored procedure code would also have been helpful.
That said, there are a couple of possibilities here.
1. In your piece of script for passing a value to p_validate, you are passing it a string (LCType_TEXT), whereas in Oracle a Boolean is a value of 0 or 1.
2. There are a handful of issues with the Boolean datatype and Oracle (it's not a valid Oracle column type [although it's fine for a stored procedure]; some connectors such as Oracle JDBC don't support passing Booleans as a parameter; you can't include Booleans in an SQL statement; it's not explicitly stated to be a problem in the LSX Help but it's also not on the list of supported Oracle data types).
For these reasons, if you continue to have trouble with this Boolean value, I would suggest replacing it with a simple INT type within the stored procdure, and send an INT value parameter which will be handled appropriately in your logic. (It doesn't need to specifically be a Boolean if you simply treat the int value of 0 as FALSE, and 1 for TRUE!)
If you need more help, please include the rest of the needed information.
Return to top
. . RE: Need to call API from Oracle us... (Daniel W Heiche... 30.Dec.14)
Print this page
