This week's book giveaway is in the Design forum.
We're giving away four copies of Design for the Mind and have Victor S. Yocco on-line!
See this thread for details.
Win a copy of Design for the Mind this week in the Design forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Properties File For Oracle

 
Patricia Samuel
Ranch Hand
Posts: 300
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

Could somebody help me in configuring SQL files -

I have a package body that have procedure for inserting data. it takes cursor to iterate. I have put cursor in header file. Is there any way we can have the sql select query in some file and refer the query from file into cursor.

Please help or let me know any way so that i can manage queries in some property file and refer query into cursor from this file.

Thanks
Patricia
 
Agador Paloi
Ranch Hand
Posts: 118
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Patricia -

Maybe you could create a sql_properties package if you have that
many cursors . the package would contain all cursor sql used by other packages.

The using packages could execute dynamic cursors or sql_properties package
could contain the actual open- fetch- close cursor logic invoked by other packages.




Agad
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic