Search results for query: *

Hi, I am importing some data into a table from a delimited text file. Unforturnately the text file contains NULL records: ID|First Name|Last Name 1|John|Smith 2|Mary|White 3|Ken|Gray My question is how can I signal to SQL Loader to ignore any null record. Thanks for your...

Is there an approach to traverse the columns of a ref cursor to extract the column information (i.e. column name and value) in PL/SQL? I can do this with Visual Basic's recordset object. Here's VB code of what I would like to do in PL/SQL: i.e. set rs = cn.execute("select * from...

I would like to import data from a text file into a temp table in SQL Server. However, the temp table has an identity column. How can I indicate that it should automatically generate an identity value for each imported record?

I have a dblink from Oracle to SQL Server. I need to be able to call a SQL Server stored procedure and pass it some parameters. Does anybody have any clue how to do this?

I would like to update/insert data from Oracle to SQL Server using a Oracle stored procedure. The procedure contains an insert statement that inserts data into a SQL Server table. I run the Insert statement standalone and was able to insert the entry onto SQL Server. However, using Oracle stored...

Hi, Here is the general scope of my issue. I need to execute an arbitrary stored procedure/function. Only the name of the procedure is available and it is the result of a lookup from a table. At this point, I do not know the arguments (argument name, in or out or the data type) the arbitrary...

Hi, I would like to find out if there is another way to optimize my query or other ways I can make it run faster. The query attempts to determine the nodes in the List where the node return is the highest level in its branch within the List. The query takes around 5 minutes. Your feedback is...

Hi, I encountered the above error when attempting to call a function in a SQL statement. That called function in turn calls some other functions depending on the transaction type. According to the documentation for the error message, I need to define Pragma Restrict_Refeerences. I have...

Hi, I need to produce a report for employee list, listing the subordinates of an employee in a tree structure (the hierarchy of command). The table structure is as follow, Employee_ID Work_For Emp_Name 1 0 Boss 2 1...

Hi I get a compilation error when trying to reference a database in my stored procedure. I am suspecting that it is becasue the database name begins with a digit. Does anybody know of any other approach to reference the database that begins with a number? I tried putting single and double...

Hi, I am trying to load data using SQL*Loader 8.1.6 loading to Oracle 7.3.4. The following are the error message that I got in the log file: SQL*Loader-282: Unable to locate character set handle for character set ID (0). Does anybody have other resolution besides using compatible client and...