• Post Reply Bookmark Topic Watch Topic
  • New Topic

How to pass cascading objects to Oracle from Java

 
Neeraj Kavedia
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi All,
Can you please help me resolve below issue.

Oracle TYPE object has below parameters.

So i need to create SEGMENT_OBJ as a final object in Java (which should include TIER_OBJ, CAMPAIGNENROLLMENT_OBJ_ARR etc.) to pass to Main Procedure as an object parameter.

Need your help creating a JAVA method for this ASAP.

Thanks you so much in advance.


Regards
Neeraj Kavedia
 
Brian Tkatch
Bartender
Posts: 568
25
Linux Notepad Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I do not know enough about this topic to give a good answer, but i will guess anyway. I think you need to create a stored procedure to accept parameters from Java and it will handle the type.

On a side note, why are you creating objects in SYS? I don't think that is a very good idea. Perhaps you should be creating them in a different schema, made for the application.
 
Neeraj Kavedia
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Brain,
Thanks for the reply.

No Sir, it is other way round, I need to create a JAVA method which passes SEGMENT_OBJ into oracle stored proc.
I already have a stored proc for the same.

Regards
Neeraj
 
Neeraj Kavedia
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello Guys,
Anyone out there to help??

I need this bit urgently.

Thanks.


Regards
Neeraj
 
Stephan van Hulst
Bartender
Posts: 6646
90
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Have you already been through the JDBC tutorials?

https://docs.oracle.com/javase/tutorial/jdbc/basics/index.html
 
Gravity is a harsh mistress. But this tiny ad is pretty easy to deal with:
the new thread boost feature: great for the advertiser and smooth for the coderanch user
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!