Calling Oracle Package from Grails -

Calling Oracle Package from Grails -

is there way phone call function / procedure within oracle package? able phone call stored procedure :

sql.call 'call myproc(param1,param2)'

and when tried apply same thing bundle :

sql.call 'call mypackage.myfunction(param1,param2)'

i had error : ora-06576: not valid function or procedure name

any help?

thanks !

try syntax:

sql.call '{call mypackage.myproc(?,?)}', [p1, p2]

and if function:

sql.call '{? = phone call mypackage. myfunction(?,?)}', [result, p1, p2]

oracle grails stored-procedures groovy