calling Oracle plsql from pro IV
Posted 20 October 1999 - 08:47 AM
(version 4.6) on an NT platform. On every call we get the error message '366 - invalid SQL'. The pl/sql runs fine
Somewhere I saw that to call the module you put the following in your pro iv code
exec module_name($var1, $var2 ....) - the same as a normal
Oracle sql plus call
I am an Oracle person not pro iv so now I am stuck !!
Any help would be appreciated.
We are on Oracle 22.214.171.124.5a and all of our normal
user written embedded SQL works fine.
Posted 20 October 1999 - 05:18 PM
I remember doing some Oracle stuff through ProIV, and I seem to recall that if you want to pass variable parameters through to SQL statements, then for some unknown reason you should put a colon infront of them.
where STATUS = :$STATUS
I hope this helps.
Posted 21 October 1999 - 01:04 PM
$$SQL_CMD = 'BEGIN module_name(' + ''' + $P1 + '',''
+ $P2 + '',' + CONV(#P3) + ',' + CONV(#P4) + ',' +
CONV(#P5) + ','' + $P6 + '','' + $P7 + '','' + $P8 +
'','' + $P9 + ''); END;'
#STAT = SYS-SQL($$SQL_CMD)
Hope this helps.
Reply to this topic
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users