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 wOOdy-Soft 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: xrodge
  • Content: Threads
  • Order by date
  1. xrodge

    Help needed passing arrays between VB and Oracle

    Hi, I am having a problem with passing pl/sql tables (arrays) as a variable. I can pass such a table between Oracle procedures without a problem, but I need to be able to pass it to VB and would also like to be able to read an array passed to me from VB. I have the following VB code: Dim...
  2. xrodge

    Passing pl/sql tables as a variable

    Hi, I am having a problem with passing pl/sql tables as a variable. I can pass such a table between Oracle procedures without a problem, but I need to be able to pass it to VB and would also like to be able to read an array passed to me from VB. I have the following VB code: Dim iCommand As...
  3. xrodge

    PL/SQL Ref cursors problem

    Hi all, I am having a little problem with ref cursors that I hope someone can help me with. I am trying to use them to generically audit any table on the system. That means, the procedure will never know what the table structure or columns involved are until it is called. This is my code...
  4. xrodge

    ORA-04091 Mutating tables problem

    Hi All, I have a problem in that I am getting error ORA-04091 in a trigger I am writing. I can see why I get it, but not how to get around it. The basic idea is, I have a table which can have any amount of rows for a project. If a row is deleted, I want to check if there are any other rows in...
  5. xrodge

    Oracle sql, passing parameters into a procedure problem

    I have an sql query that hopefully someone will have time to look at: I want to pass a series of numbers into a procedure, ie 1,3,5,6,7,8 and then be able to use them to access a cursor. Unfortunately, it keeps giving me an invalid number error when I try to run it. So, I tried to pass them in...

Part and Inventory Search

Back
Top