FORMS_DDL - Forms

Hello,
Is there any difference between FORMS_DDL('ROLLBACK') and ISSUE_ROLLBACK?
Thanks,
Burt 

see Article-ID: <Note:73121.1>
it gives you some explains why or when you should use ISSUE_ROLLBACK
i hope it helps

Related

Passing a ResultSet from java proc to PLSQL

Has anyone found the docs/samples that show how to pass a ResultSet FROM a java sp TO a PLSQL sp?? There must be a way to do this!
Thanks,
Paul Conner 
Hi Paul,
Have you seen this web page:
http://asktom.oracle.com/pls/ask/f?p=4950:8:1301043::NO::F4950_P8_DISPLAYID,F4950_P8_B:1526005944436,Y
I know it describes the opposite to what you require -- but I don't
think it should be a problem to swap the process.
Hope this helps.
Good Luck,
Avi.
Thanks, I have reviewed the article that you mentioned but it doesn't seem to be a "clean" way to do this. I am hoping that there is some way to cast the resultset to a generic ref-cursor and pass it that way.
Thanks non-the-less,
Paul Conner 
Thanks to The Master of PL/SQL (Steven Feuerstein) and his obviously very competent friend (Alex Romankeuich) the answer was chased out of MetaLink.
Please see note # 150448.1 for the clean solution available in Oracle 9.2.
Happy Hunting!

export to csv

Is there a function in PL/SQL by which I can export the records retreived by a select query to a file in a CSV format.
Thnx in advance.
Ameya. 
Yes. You go check in the documentation for UTL_FILE.
Cheers
Sarma. 
For a ready-to-use solution see Tom Kyte http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:235814350980 
Paul,
For your information, the TinyURL Web site makes short URLs out of long ones.
Here is what it produced for your link to the AskTom Web site:
http://tinyurl.com/oxkn2
Impressive, no?
Good Luck,
Avi. 
Yes, indeed.
Thanks Avi. 
Here is some other Tom Kyte link which might help
http://asktom.oracle.com/~tkyte/flat/index.html

Reference to HTP.P

Hello,
Where can I find some detailed description of HTP.P ? I looked at "PL/SQL Packages and Types Reference", saw an example using HTP.P but not any details on the function itself.
Thanks,
Arie. 
You can refer to :
http://www.di.unipi.it/~ghelli/bdl/A97329_03/web.902/a90101/pshtp.htm#1007042
Rgds
Ravikanth 
Hi,
HTP packages are the PL/SQL cartridge packages.
You can find thr right documentation by searching for
PL/SQL cartridge functions.
Rgds.
Amogh 
Hello Ravikanth,
Thanks on your reply. Unfortunately, your link is to the entire HTP/HTF packages documentation. I already looked there, but didn't find any specific reference to HTP.P (although I agree this is the natural place to look …)
Any other references out there?
Thanks,
Arie. 
Hi,
Did you try searching for PL/SQL Cartridge functions? You'll get many links.
Try this one:http://www.oreview.com/9705honr.htm
Rgds.
Amogh 
HTP.P is just an abbreviation for HTP.PRINT. The documentation does not make this very clear, but it is noted in the install script on the server ($ORACLE_HOME/rdbms/admin/pubht.sql) 
Thanks to all of you on your replies.
So simple, and yet...
Arie. 
I'm glad you found out about HTP.P. Now what about the rest of the package?
Percy, who posted this week looking for answers.

Where is perf.zip

Where can I get the performance test code mention in this doc
http://www.oracle.com/technetwork/database/berkeleydb/berkeley-db-perf-128909.pdf
Its not here http://www.oracle.com/technetwork/middleware/ias/perf-129688.zip or here http://www.oracle.com/technology/products/berkeley-db/files/perf.zip
TIA
Adrian 
Hello,
perf.zip, containing the performance code, should now be available at:
http://www.oracle.com/technetwork/database/berkeleydb/downloads/perf-186166.zip
Let me know if you have further problems. There have been some issues with updated links lately, so thanks for reporting this.
Thanks,
Sandra 
Thanks Sandra, link works perftectly.

free pl/sql video tutorials

hiii,
Can you please some links which contain the oracle( sqk or pl/sql) video tutorials.....
Thanks in advance 
Hi,
Steven Feuerstein is a well known referent in PL/SQL. See this link [Steven Feuerstein PL/SQL Obsession|http://www.toadworld.com/Knowledge/DatabaseKnowledge/StevenFeuersteinsPLSQLObsession/tabid/153/Default.aspx] and specially [Practical Best PL/SQL Video Series|http://www.toadworld.com/Knowledge/DatabaseKnowledge/StevenFeuersteinsPLSQLObsession/PracticalBestPLSQLVideoSeries/tabid/154/Default.aspx]
I hope it can help you.
Regards, 
Hi walter, thanks for the URL. I'd never know the existence of the wonderful resource without ur help.
Om 
981598 wrote:
Hi walter, thanks for the URL. I'd never know the existence of the wonderful resource without ur help.
OmAlright, Now that you have known such a wonderful resouce, Stop re-surrecting Old threads.
If you need any details, Google is your best friend, if not, then post a Thread in relevant forum with your question.

Categories

Resources