I\'m having trouble calling开发者_开发问答 an Oracle stored procedure in Java. I added a stored procedure to the database like this:
The PL/SQL script shown below is failing to execute at line # 20: declare type string_table is table of varchar(100);
开发者_StackOverflow社区I am getting this error: Error starting at line 2 in command: BEGIN DELETE * FROM book_copies;
So I\'m trying to call an Oracle stored procedure from my C# .NET application. Most online references I can find suggest \"using System.Data.OracleClient;\", but .Net 3.5 doesn\'t recognize that names
When i\'m using this command apex_application.g_print_success_message := \'<span style=开发者_开发百科\"color:GREEN\">Message</span>\';
This is code to connect to an Oracle database. It fails at the last line: dbDataAdapter.Fill(dtResult);
i have a holiday table which contains the data are HOLIDAYDA DESCRIPTION --------- --------------------
I have a query that queries on ReportStartDate and ReportEndDate so I thought I would use variables in PLSQL. Not sure what I am missing here, but I get an error:
HI, I am using UNIX OS and working on oracle. I am getting the error message below E ORA-06550: line 1, column 8:
I have a varray defined like: declare TYPE tnr_l IS VARRAY(30) of lve%ROWTYPE; I want this varray to be initialized with a fetch from the database: