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
This is part of the error report.  I can post the whole thing if it would help. Terminating app due to uncaught exception 'NSMallocException', reason: 'NSImage: Insufficient memory to allocate pixel data buffer of 44800 bytes.Bonjour PanicRev16    I [More]
I have been trying to sync my iMessages between my iPhone 4s and my macbook pro but it will only use my email. I have been told to change the setting in the message menu but I can't seem to find that! Help me please!!! Thank you!TRy to check on your [More]
Hi all.. I am developing an applet that records sound and stores it in a WAV file... The applet is signed and loads in the browser well but it does not give the output, i.e. the WAV file in the specified directory. Can you please have a look at my co [More]
Hi All, I am trying to write some BPEL processes that will be sending EDI Documents to Integration B2B using the AQs. BPEL works with XML data and finally enqueues it to the AQ IP_OUT_QUEUE. From there B2B will pick up and send to Trading partner. I [More]
Hi ALL Just a quick question.....I am doing payroll reporting using logical database PNPCE, do I need to use standard includes for payroll. if yes why these includes are used for. cheers AJyou need not use any standard includes Use the following code [More]
Is there a Lightning to thunderbolt adapter?Hi Faster77, Welcome to the Support Communities! The article below explains that Thunderbolt cables and adapters are for Macs. If you want to project content on your iPad to your Mac or TV, you would use Ai [More]
32 GB New  imac, working great in Mavericks (well, except the audio interface and click problem!) BUT, now... with every click in a Word document, the beachball begins to spin. EVERY CLICK! Painstaking work! Tried several suggestions that are out the [More]
I've just gotten back to working with our KE237 sourcemeter. I just discovered a couple of new bugs in the LV drivers posted here and at Keithley. It's a pretty unique old instrument, and we're lucky that they still make it, but it has some rough edg [More]
Hi Experts, Can any tell me why do I get an error message "You are not authorized for given plant and mvt tpe" when I try to do a PGI for a delivery of sales order. thanks in advance.Hi Ashwin In realtime there will limit to user to access to so [More]
I am trying diligently to build a TestStand deployment and keep getting errors. TestStand is telling me that an error has occurred because it cannot find a sub-VI in a certain path. The problem is it does not tell me what VI it cannot find a sub-VI f [More]