Skip to content

XAware Community

Get the Flash Player to see this player.
Flash Image Rotator Module by Joomlashack.
XAware 5.6
Need Help
Webinars and Events
Advanced Tutorials
Webinars and Events

You are here: Home arrow Forums
XAware Community Forums
Welcome, Guest
Please Login or Register.    Lost Password?
Re:passing custom oracle types to a stored procedure (1 viewing) (1) Guest
Go to bottom Post Reply Favoured: 0
TOPIC: Re:passing custom oracle types to a stored procedure
#6032
kilyas (User)
XAware user
Posts: 27
User Offline Click here to see the profile of this user
passing custom oracle types to a stored procedure 9 Years ago Karma: 13  
We have a stored procedure which accepts an array of BLOB defined as
type img_array is varray(50) of BLOB

and an array of VARCHAR defined as

type attachment_id_array is varray(50) of VARCHAR2(50)

What is required ot be done is to call this stored procedure using XAware. I have not been able to figure out how to create/pass these custom types to XAware business component. I have looked into XAware documentation but have nto been able to find anything in this regard.
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#6033
tferguson (User)
XAware expert
Posts: 494
User Offline Click here to see the profile of this user
Re:passing custom oracle types to a stored procedure 9 Years ago Karma: 6  
Sorry to say, but XAware does not support varray. You will need to either change your Stored Procedure or you can use the Java BizComp.
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#6040
allenritz (User)
XAware member
Posts: 1
User Offline Click here to see the profile of this user
Re:passing custom oracle types to a stored procedure 8 Years, 6 Months ago Karma: 0  
First you need to create a user defined type/custom type in Oracle which represents .Net Object and another UDT as a table of these objects. Then use ODP.Net to map between .Net Custom Objects to Oracle UDT types.

Managed Hosting Providers
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
Go to top Post Reply
Powered by FireBoardget the latest posts directly to your desktop

Community Login

Get the Flash Player to see this player.
Flash Image Rotator Module by Joomlashack.
Commercial
Free Training
QuickStart Packages
Image 4 Title
Image 5 Title

Visit XAware.com