Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: ek03
  • Order by date
  1. ek03

    Question on truncate and delete.

    I'm not sure what you want to do - are you looking for a way to set the data in one column to null? If so, you can do an update like jimbopalmer suggested - update tbl set Jan = null
  2. ek03

    Question on truncate and delete.

    You can't specify a where clause for a truncate, but you can for the delete command: delete from tbl where month = 'dec'
  3. ek03

    Loading a text file...automation

    The utl_file utility can be used to load files that are on any network computer - you have to set the file path parameter like this: utl_file.fopen('\\pathToTheFile', 'myfile.txt', 'r'); This will open the file for read access. You can then read the file line by line using the get_line function.
  4. ek03

    PL/SQL proc - sequences - how to get currval

    Another way you can do this without changing the trigger is by adding a returning clause to the insert: insert into mytable(x, y) values(:a, :b) returning id into myIdVar; The trigger will populate the id column and the value will be returned into the myIdVar variable, which you can then use...
  5. ek03

    Execute Immediate

    Yes, you would need a commit after executing a DML statement using execute immediate.
  6. ek03

    limit on size of plsql table

    I will send you a pared down version - it's a rather complicated process, but I can send you snippets of the relevant code. I was very surprised to see what was happening too - but I put in a dbms_output immediately before the called procedure returned and then immediately after, and sure...
  7. ek03

    limit on size of plsql table

    Hi. The error was on your_tab(your_tab.last), which should have existed - in the called procedure, your_tab.exists returned true, but once it returned to the main procedure, exists returned a false.
  8. ek03

    STRANGE BEHAVIOUR FROM ORACLE-VERY CRITICAL ISSUE

    Hi. If you know what the plan is you'd like to see, you can specify it in a hint - to use a nested loop join, you can use the use_nl(table_a, table_b) hint. Have you tried doing this? (It will join the tables in the order listed inside the parenthesis.)
  9. ek03

    STRANGE BEHAVIOUR FROM ORACLE-VERY CRITICAL ISSUE

    Try putting a hint in the query - /*+rule*/. This will prevent Oracle from using the statistics when creating the execution plan.
  10. ek03

    limit on size of plsql table

    I don't know how I'm getting the error - I'm definitely within the bounds of the collection. The size of the table is between 20 and 200 records. Someone here at work gave me a workaround option - instead of using a plsql table, I am using a temporary table - create global temporary table...
  11. ek03

    limit on size of plsql table

    I don't know how I'm getting the error - I'm definitely within the bounds of the collection. The size of the table is between 20 and 200 records. Someone here at work gave me a workaround option - instead of using a plsql table, I am using a temporary table - create global temporary table...
  12. ek03

    limit on size of plsql table

    The table is not an index-by table (in your example, you were using a table declare as index by binary_integer) - for such a table, you are right. This is a nested table, so the indexes are incremental (1, 2, 3...) and you should only see a no_data_found if a specific record has been deleted.
  13. ek03

    Debugging a procedure using TOAD...spooling in a procedure

    Try one of these methods inside the procedure: dbms_output.put_line('value of myvar:' || myvar); TOAD has a display screen for output generated through dbms_output - just make sure to turn output on (the button should be green, not red) or you can output to a file: declare a file handle -...
  14. ek03

    limit on size of plsql table

    I am using a plsql table to store records within a procedure. This table is passed to an outside procedure as an in/out parameter. The second procedure adds records using the extend method on the table and then returns. At that point I sort the table but I am finding that the last records in...

Part and Inventory Search

Back
Top