How to handle NUMBER data type of SQL

[Former Member]

Hello All,

I have to call an Oracle store procedure developed by 3rd party, it has once of the input parameter as NUMBER.

Since NUMBER SQL data type is not support by PI 7.0 (http://help.sap.com/saphelp_nwpi71/helpdata/EN/44/7b72b2fde93673e10000000a114a6b/content.htm),

when I am execute this scenario, it through an error for - Unsupported parameter type 'NUMBER'.

I cannot change the store procedure or any thing in Oracle.

I gone through some thread but did not find any help.

Please let me know if there any work around.

Thanks in Advance.

Pradeep

[Former Member]

Thanks for your reply.

I cannot customize the stored procedure parameter to NUMERIC, as this is standard SP is from a product.

Below is the final XML generated with error on PALC and PREL parameter for NUMBER, ideally it should be

<PALC isInput="true" type="NUMBER"/>

<PREL isInput="true" type="NUMBER"/>

<Statement xmlns="">

<LSA_REL_DM action="EXECUTE">

<table>ACQDR.lsa_rel_dm</table>

<PPROJECTID isInput="true" type="VARCHAR">85LJ24210</PPROJECTID>

<PDMC isInput="true" type="VARCHAR">LJ200-A-J00-00-00-00-00AAA-00K-AA</PDMC>

<PLCN isInput="true" type="VARCHAR"/>

<PALC isInput="true"/>

<PTYPE isInput="true" type="CHAR"/>

<PSOURCE_CODE isInput="true" type="VARCHAR"/>

<PREL isInput="true"/>

<PRFU isInput="true" type="VARCHAR"/>

<POBJECT isInput="true" type="BLOB">&lt;dmodule xsi:noNamespaceSchemaLocation="C:/Projects/S1000D/Document/schema/TIR_Parts_Vendors.xsd" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"&gt;&lt;identAndStatusSection&gt;&lt;dmAddress&gt;&lt;dmIdent&gt;&lt;dmCode modelIdentCode="LJ200" systemDiffCode="A" systemCode="J00" subSystemCode="00" subSubSystemCode="00" assyCode="00" disassyCode="00" disassyCodeVariant="AAA" infoCode="00K" infoCodeVariant="A" itemLocationCode="A"/&gt;&lt;language languageIsoCode="US" countryIsoCode="sx"/&gt;&lt;issueInfo issueNumber="0" inWork="1"/&gt;&lt;/dmIdent&gt;&lt;dmAddressItems&gt;&lt;issueDate year="20111107" month="20111107" day="20111107"/&gt;&lt;dmTitle&gt;&lt;techName&gt;General&lt;/techName&gt;&lt;infoName&gt;Organizations technical information repository&lt;/infoName&gt;&lt;/dmTitle&gt;&lt;/dmAddressItems&gt;&lt;/dmAddress&gt;&lt;dmStatus&gt;&lt;security securityClassification="01"/&gt;&lt;responsiblePartnerCompany enterpriseCode="24210"&gt;&lt;enterpriseName&gt;Learjet&lt;/enterpriseName&gt;&lt;/responsiblePartnerCompany&gt;&lt;originator enterpriseCode="24210"&gt;&lt;enterpriseName&gt;Learjet&lt;/enterpriseName&gt;&lt;/originator&gt;&lt;applicCrossRefTableRef&gt;&lt;dmRef&gt;&lt;dmRefIdent&gt;&lt;dmCode modelIdentCode="LJ200" systemDiffCode="A" systemCode="J00" subSystemCode="0" subSubSystemCode="0" assyCode="00" disassyCode="00" disassyCodeVariant="A" infoCode="00W" infoCodeVariant="A" itemLocationCode="A"/&gt;&lt;/dmRefIdent&gt;&lt;/dmRef&gt;&lt;/applicCrossRefTableRef&gt;&lt;brexDmRef&gt;&lt;dmRef&gt;&lt;dmRefIdent&gt;&lt;dmCode modelIdentCode="LJ200" systemDiffCode="A" systemCode="J00" subSystemCode="0" subSubSystemCode="0" assyCode="00" disassyCode="00" disassyCodeVariant="A" infoCode="022" infoCodeVariant="B" itemLocationCode="D"/&gt;&lt;/dmRefIdent&gt;&lt;/dmRef&gt;&lt;/brexDmRef&gt;&lt;/dmStatus&gt;&lt;/identAndStatusSection&gt;&lt;content&gt;&lt;techRepository&gt;&lt;partRepository/&gt;&lt;/techRepository&gt;&lt;/content&gt;&lt;/dmodule&gt;</POBJECT>

<PSTATUS isInput="true" type="CHAR">D</PSTATUS>

<PISSTYPE isInput="true" type="CHAR"/>

<POBJECT_CLASS isInput="true" type="VARCHAR">XML</POBJECT_CLASS>

</LSA_REL_DM>

</Statement>

Thanks in Advance

[stefan_grube]

> I cannot customize the stored procedure parameter to NUMERIC, as this is standard SP is from a product.

> Below is the final XML generated with error on PALC and PREL parameter for NUMBER, ideally it should be

> <PALC isInput="true" type="NUMBER"/>

> <PREL isInput="true" type="NUMBER"/>

The thread does not talk about changing your stored procedure, but use NUMRIC as type in the XML statement.

<PALC isInput="true" type="NUMERIC"/>

<PREL isInput="true" type="NUMERIC"/>

[stefan_grube]

> I gone through some thread but did not find any help.

Have you tried NUMERIC as proposed in the thread?

[abhradeepbasu]

Are you really sending numbers? If the value is number then automatically it should convert.

[gagandeep_batra]

Hi,

If u can add another function in oracle. then add one more function which take parameter as string and in that function u convert that value to number and call the other procedure which u want to call.