NUMBER type for Oracle SP

[Former Member]

Hi,

I try to execute a stored procedure in oracle.

When I use EXECUTE Statement I get the error Unsupported parameter type 'NUMBER' for... In help.sap.com I read that type NUMBER is not supported.

Is there any work around? If not will it work in SQL_QUERY Statement?

[Shabarish_Nair · Accepted solution]

try using NUMERIC

[Former Member · Accepted solution]

Yes, numeric helped but the stored procedure also uses NCLOB which is also not supported Is there anything I can use instead of it? I used CLOB but it fails. It inserts wrong data.

[Former Member · Accepted solution]

When trying to send characters like ğ ş ç it deletes them and inserts just the other part?

[Former Member · Accepted solution]

Sorry,

the problem is when receiving the message from RFC. The letters are getting cut there. Not while inserting into DB. I think there should be any option in RFC destination?

[former_member200962 · Accepted solution]

When trying to send characters like u011F u015F ç it deletes them and inserts just the other part? 

I think there should be any option in RFC destination?

Assuming that you are still looking for that option in RFC destination....Check if you have maintained Unicode option in your RFC destination.

Regards,

Abhishek.

[Former Member · Accepted solution]

Perfect answer Thank you!

[Former Member]

Try NUMERIC.

[former_member181962]

Try NUMERIC.

Check this link for all the supporeted data types:

http://help.sap.com/saphelp_nwpi71/helpdata/EN/44/7b72b2fde93673e10000000a114a6b/content.htm

Regards,

Ravi