Using Oracle PL-SQL

Email Alerts

Register now to receive SearchOracle.com-related news, tips and more, delivered to your inbox.
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

  • ORA-00904 with database link

    I've created a database link between a 9i and 8i database. It works but the same SQL in a PL/SQL block fails with "ORA-00904 : COL4 : identificateur non valide."  Ask the Expert

  • When did Oracle begin implicitly closing cursors?

    In your response regarding cursor memory leaks, you said: "It used to be that if you did not close a cursor, that memory stayed allocated and unusable to anything else. This is no longer the case with Oracle." Do you know with what version Oracle sta...  Ask the Expert

  • Oracle unveils free SQL Developer: Has Toad met its match?

    Oracle's newly released free SQL Developer could spell trouble for Quest Software Inc.'s popular Toad for Oracle software.  Article

  • Log execution time for a procedure

    I need to somehow log the execution time for two procedures every time they are called and save that data (in a table?). Do you know of a way to isolate tracing to a specific procedure in order to do this?  Ask the Expert

  • Loading data into Oracle

    I need a step-by-step procedure for importing text to an Oracle database using a stored procedure.  Ask the Expert

  • Detect if a column is NUMBER or VARCHAR2 in PL/SQL

    How can I tell if a column is a NUMBER or VARCHAR in PL/SQL? Is there a function to do this?  Ask the Expert

  • Using PL/SQL for ETL

    How can PL/SQL be best used for the ETL process?  Ask the Expert

  • Why doesn't a select statement speed a module run?

    I am using Oracle 9i. I have a PL/SQL module that uses a local procedure for 20% of its time. The procedure consists of a SELECT INTO statement. Rewriting this statement using analytics gives a query plan costing, which is an order of magnitude less ...  Ask the Expert

  • Difference between function, procedure and trigger

    What is the difference between a function, a procedure and a trigger? I know the basic differences, but I would like to know the answers based on the performance tuning aspect.  Ask the Expert

  • Can I redirect output of an external table to an internal table?

    Can I redirect the output of the bad file and log file of an external table into another internal table in Oracle 10g? Also, can I create a function object on an external table?  Ask the Expert

Back to top