LL upgrade & oracle problem

[tmorsi]

hi,

looking for some help regarding errors during 9.7.1 upgrade.

we've got a script that executes some oracle sql package but we are receiving the following errors (which did not occur in 9.5):

Oracle error: (904) --> ORA-00904: : invalid identifier
KSqlCursor::Open(201f,'SELECT utillib.pvv_GetNVPValue('AGT', null, :A2) "value" FROM dual') -->'Could not prepare cursor.'

the actual script code is:
stmnt = Str.Format("SELECT utillib.pvv_GetNVPValue('%1', null, :A2) %2value%2 FROM dual", objName, '"')

results = CAPI.Exec(connection, stmnt, name)
if isError(results)
echo("error1")
end


no matter how we change the above sql statement we keep getting the same error ...

any insight is much appreciated
thanks

 

[appnair]

what would happen if you tried this without livelink in the picture that is thru sqlplus or such like?

Well, if I called the wrong number, why did you answer the phone?
James Thurber, New Yorker cartoon caption, June 5, 1937
Certified OT Developer,Livelink ECM Champion 2008

http://www.tek-tips.com/faqs.cfm?fid=2884

http://www.linkedin.com/in/appunair

 

[tmorsi]

yea we tried that without livelink & it did work (using the correct input)

but actually it looks like some of our people solved it;

it was a permissions issue for the particular oracle library packages.

9.5 had rights in the db to the sql libraries/packages but 9.7.1 did not;

the error message that we were receiving (from 1st post) didn't make it clear this was the case;

much appreciated for all the help