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
Hi Im currently trying to import a file (word file / excel I have both formats) into an indesign book and formatting the text automatically! My question is: How is it possible to reflow text into frames and when changing frame it changes paragraph? O [More]
I have read all the threads and the logs. I have ended up with all versions of SQL Servers upto 2014. However, I get the same error. The best part is Microsoft support has not come up with a single simple answer to fix it. It appears like a wild goos [More]
Hi all, when i press F8 to execute the report, an internal copy will be saved automatically. And, when there are filled of these copies, i can not press F8 without Activate the report. Plz someone help me to delete these copies, or give me a solution [More]
Hi, I'm required to refresh our production database from a warehouse. There are a number of tables to be refreshed. Now, I cannot have materialized views that does incremental refreshes since the tables in the warehouse do not have mview logs on them [More]
Hi, I restarted my database (RAC). After that I am getting ORA-12514 from second node while trying to connect username/[email protected], but it is working in first node. Can any body will help me. Regards, KiranHi, I am getting the following message: in 1 st n [More]
I want to know how to turn off smartfilter in Firefox. Turn It Off!!!When you go to a site that triggers Smart Filter it prompts you to contact the administrator. I just got this laptop from a friend. It is mine now and I am the administrator but I s [More]
Dear gurus, Could you please let me know if the following logs are stored in the DB or at file system? - ABAP runtime error logs (ST22) - Background job logs (SM37) - System logs (SM21) Best regards RodolfoAs far as i know - ABAP runtime error logs ( [More]
Every time I set up a stock personal ringtone or text tone it reverts back to the default, Why?yes, i have the same issue too... is there a way to change your notification tone? the only way i kno to change tones is through settings->sounds.... is th [More]
Learning - from how to capture to how to do basic edits.  Trying to use warp stabilizer on some hand-held footage and got the red "NO" message.  Can I still do this, or did I do my edits in the wrong order as in I should maybe have used warp sta [More]
I've lost my photos (crashed hdd, iPhoto library on Time Machine corrupt too).  Is there a way to create a picture from the thumbnail that remains in iPhoto?  The quality is obviously poor, but better than nothing.Time machine should have a good copy [More]