Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • 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: 567
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
Pie
Posts: 6503
83
  • 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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic