Sitemap

Amicuk Programming Answers

Database Adapter: NVARCHAR2 datatype in stored procedure

2015-10-11   Views:1

Advertisement

Hi, when I try to define partner link as database adapter - call stored procedure with datatype NVARCHAR2, I'm getting following error: Error while writing wsdl file ..... Exception: WSDLException: faultCode=OTHER_ERROR: Database type is either not s

Hi,
when I try to define partner link as database adapter - call stored procedure with datatype NVARCHAR2, I'm getting following error:
Error while writing wsdl file .....
Exception: WSDLException: faultCode=OTHER_ERROR: Database type is either not supported or is not implemented. Parameter INP_TEL is of type NVARCHAR2 which is either not supported or not an implemented datatype.
Is it possible to wokaround this problem without changing datatype nvarchar(utf16) to varchar2(iso8859p2)?
There should be no difference between mapping of varchar and nvarchar to string at BPEL side.
BPEL version: 10.1.2.0.0
Regards
Karel

The replay answer
Advertisement
Better workaround is to define stored procedure with varchar datatype, generate wsdl
and then change stored procedure definition to nvarchar.
This works and mapping (java) string to (oracle) nvarchar2 is correct.
But sometimes this could be difficult ( invalidations of thousands objects).
Maybe there could be better solution like add mapping to some files ???
Karel

Go to See the other 3 answers

Database Adapter: NVARCHAR2 datatype in stored procedure

Category:DefaultRelease time:2015-10-11Views:130

Hi, when I try to define partner link as database adapter - call stored procedure with datatype NVARCHAR2, I'm getting following error: Error while writing wsdl file ..... Exception: WSDLException: faultCode=OTHER_ERROR: Database type is either not s[More]

Sender JDBC adapter : Update SQL Statement : stored procedure

Category:DefaultRelease time:2015-10-11Views:130

Hi, Can we use a stored procedure in the sender jdbc adapter in 'Update SQL Statement'. The problem i am facing is like, we are selecting data from two tables in 'SQL statement for query' and then in 'Update SQL Statement' , we need to delete that da[More]

Synchronous JDBC adapter(receiver side) with stored procedure

Category:DefaultRelease time:2015-10-11Views:130

Hi experts, Can some database processing logic be included in receiver JDBC (synchronous) adapter...to put it simply I have synchronous JDBC adapter in the receiver side..Using this JDBC adapter I want to get some response back from the table.. The r[More]

How can I check a Remote Database is alive in a Stored Procedure

Category:DefaultRelease time:2015-10-11Views:130

Hi In a PL/SQL stored procedure, I do a select from a table on a remote database via the database link. There is a Loop around the select as it waits for a flag to be set on the remote table. However, on several occasions, while looping, the remote d[More]

Parameters of Date Datatype for stored Procedure

Category:DefaultRelease time:-0001-11-30Views:130

I have a stored procedure where i hav two date parameters..initial i had the parameter datatype as varchar and in query i used the format to_date(fromdate ,'dd/mm/yyyy') My fromdate is in the format 31-01-2010 everything worked fine...now i changed t[More]

TEXT datatype in Stored Procedure and concat Carriage returns

Category:DefaultRelease time:-0001-11-30Views:130

Anyone, I am trying to create a stored procedure that will allow me to grab a bunch of 255 Char records in a cursor and concatenate them together adding a carriage return after each row. Here is pseudo code would look like: CREATE OR REPLACE PROCEDUR[More]

Connecting to a non-oracle database (jdbc) from a java stored procedure

Category:DefaultRelease time:-0001-11-30Views:130

Does anyone know to configure the database to allow a connection to a non-oracle database from a Java Stored procedured, using JDBC? Thank you in advance, ChrisHi Chris, I haven't tried it, and these are just some of my thoughts, but I think you woul[More]

Unknown Database Connector Error using Oracle stored procedures

Category:DefaultRelease time:-0001-11-30Views:130

We are using an Oracle database for the first time with our Crystal Reports, and I am attempting to modify a report to use a new stored procedure.  When I attempt to add either the new procedure, or to add a new copy of the existing procedure, I get[More]

Database updation using XML and stored Procedure?

Category:DefaultRelease time:-0001-11-30Views:130

Hello, I want to perform updation in multiple tables using XML files.Please suggest can I do updation using xml and stored procedure. If yes then which is more efficient and takes less time. 1.Updation using xml files only 2.Updation using xml files[More]

How to invoke a stored procedure in database adapter

Category:DefaultRelease time:2015-10-11Views:130

Hi All, i have created a database adapter which contains a stored procedure, the procedure is merge process,which bring data from another database, i have made sure that checking for new records and updating any changes from the source database every[More]

Database Adapter and SQL Server procedure issue

Category:DefaultRelease time:-0001-11-30Views:130

Hello, I am using Jdev 11.1.1.7.0 and SQL Server 2005. In the Database Adapter configuration wizard, Specify Stored Procedure step, I choose the "GEACupax" schema and got the following error after a click on "Procedure Browse" button:[More]

Hot
Please help... So I had my Mac Book completely wiped out and when I got it back it was like buying it from scratch. This machine is 4 1/2 years old, never had a problem till now. I am trying to sync my Iphone 4 to Itunes but it wont accept it since I [More]
Hi SDN, I've got a problem in calling an EJB from a Repository Service... Here the steps I've follow:   -  An EJB has been created with some Business Methods in it; it has been packaged in an EAR and deployed;   -  This EJB is looked up succesfully v [More]
Hi All, Pls just let me know is ther any huge difference between architecture of Oracle 10g and 11g ?. Kindly suggest in very brief or just yes/no. Thanks,Nimish Garg wrote: There r no major difference b/w 10g & 11g Architecture check this link out f [More]
I am a storage admin trying to get a better understanding of RMAN. My question is for backuplevel.1 does RMAN require free space to write archive information or archive logs to to complete this backup? My DBA says "no" after I requested that he [More]
Dear Sir:       I just installed NI Developer Suite 8.5.   I established connectivity with my target device and can run programs.       However, there is an issue that has arisen and I require some installation specific information.        I have rea [More]
A<SYNCH-11> How do my web service methods accees EJBs and java classes? A<SYNCH-11> It is simple to use java classes, just do it as you would ordinarily. The .jws file really contains a simple class so you can program with it in the same way t [More]
Hi Experts ... Hop I can find assisstant on my problem I want to create one user to have DBA previlage on 2 databases and I want to create one tablespace shared between 2 databases any body can help me please?MHAIDAR wrote: Hi Experts ... Hop I can f [More]
One server providing OD, DHCP and DNS. DNS works perfectly, both forward and reverse. 10.4 clients sometimes login like they should, but most often the login-window just hangs and nothing more happens. In rare cases the user gets logged in after wait [More]
i just updated to  the new software, and im trying to restore me stuff from a back up i did but its not working...its asking for a password that i dont know.. can anyone help?You need to double click the Home button to get the camera button.Read othe [More]
I'm new to Mac and I'm having trouble opening my Word documents in Pages. When I tried opening one of my documents ending in .doc it gives me this error message : import error the file format is invalid. When then tried a document ending in .docx  im [More]