Mapping

[former_member240483]

Hi there,

inGraphical mapping i am passing a valuse as a constant to a stored procedure.

for ex:

source structure is:

First name: XXX

Surname:: yyy

target structure:

name: XXXyyy

number: 11

in the target structure i am assgning 11 as a constant to number field and this is passing to stored procedure..

but when i tested my interface it is giving error

'aaaaaaa' (structure 'Statement'): java.sql.SQLException: ORA-20011: Error in program aaaaa at location 40. (SET0000042) aaaa does not exist for number ORA-06512: at "PMS.GLOBAL_ERROR", line 1000 ORA-06512: at "PMS.AAAAAA", line 2674 ORA-06512: at line 1

could any one suggest this error in stored procedure or in my mapping.

Regards

Rao

[GabrielSagaya · Accepted solution]

please visit the link

http://www.techonthenet.com/oracle/errors/ora06512.php

[former_member240483]

Problem was with stored procedure..

Thanks for your inputs and time.

Regards

Rao