File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Oracle/OAS and the fly likes Properties File For Oracle Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "Properties File For Oracle " Watch "Properties File For Oracle " New topic

Properties File For Oracle

Patricia Samuel
Ranch Hand

Joined: Sep 12, 2007
Posts: 300

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.

Agador Paloi
Ranch Hand

Joined: Jan 24, 2006
Posts: 118
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.

I agree. Here's the link:
subject: Properties File For Oracle
It's not a secret anymore!