Hi
I have a situation where the attached script works fine with different SQL*Plus clients (8 and 9), on a variety of PCs (all W2K), with a variety of Oracle network databases (AIX and W2K...
I have come across the error (in the question title) while saving records from a form. Now I've tried it when running my forms with my PC acting as the server (Oracle 9i OAS) and the client (...
hello expert,
I have oracle 10g express edition install on a workstation
I have a copy of toad install on same w/s
can any one provide step by step instructions how to connect to 10g ...
is it possible convert a unix time stamp 1151530818 into oracle date format jan-22-1987
Please help. Whenever I insert a clob > 4k, I get an error message listed below:
-----
Oracle 9i (Release 2)
Java 1.4.1
-----
CREATE TABLE mytab (c CLOB);
-----
String s = a_ver...
I am making changes to a legacy VB 6 application. My VB code looks like this:
Dim cn As New ADODB.Connection
cn.CursorLocation = adUseClient
cn.Open "DSN=MYDB"
I get the follo...
I'm using TOAD for Oracle. I'm trying to execute a stored procedure with two parameters - one IN and one OUT. It looks like this:
PROCEDURE get_stuff (
parm_1 IN VARCHAR...
I am trying to connect to an oracle DB from Crystal Reports using Microsoft ODBC for Oracle
When trying now the following error shows up:
The Oracle(tm) client and networking component...
HI
My server was moved from open place to another.after that i have been unable to open the database. so i have tried recreating the control files . i have created the controlfiles succesfull...
Hi,
I have a requirement to fetch the data from oracle in form of excel file. Is there any third party tool/oracle api avialable to get the oracle data directly in form of excel.
I have...
I have a csv file where one of the fields contains the new line character, when I load the file using the sql loader it gives me the error.
Here is the data file
4/24/2000,Chemical Enginee...
I need to read excel file using PL/SQL, please provide step by step procedure.
I want to do a migration from one database to another database. The question here is, how do I actually deal with the import and export of data that uses BLOB/CLOB datatype? Normally for the r...
I work with PL/SQL 5, and DEVELOPER 6.0. The database is ORACLE 8.1.6
I replaced all references to a particular table for a PL/SQL table defined in a package in the next manner:
ty...
Dear Experts,
set feedback off
set heading off
set pagesize 0
spool abc
select * from customer;
spool off
abc.lst
---------------
SQL> select * from customer;
KC ...
When i try to click tnsnames editor from toad window i get a toad error :list index out of bounds(0).Why is this and how to solve this
I my form, everytime i try to do an insert record, i get the FRM-040508 error.
The sql for the WHEN-BUTTON-PRESSED triger is as follows simple:
create_record;
IF NOT Form_Success THEN...
The Input format will be in week number and we need to find the first day of the week in Oracle's default date format.
I tried to use, to_date('2002-49','YYYY-IW'), it did not worked. I g...
With SQL*PLus
1. set serveroutput on size 1000000
2. exec <some procedure>;
The output is viewed on the screen
With TOAD
How to get similar results,
Few questions...
1)Can you please elaborate on the SELECT....START WITH....
CONNECT BY.. CLAUSE. which we use in creating Record Group
for populating Tree.
2)Moreover my EMP table has ...
Hai,
I want to create table or create external table using procedure. But, i am not able to do it. Here the code :
CREATE PROCEDURE TEST AS
BEGIN
CREATE TABLE CLS_TEST
(
...
HI,
I am working on Oracle 8.1.7.
My Table structure is as under:
create table test_tbl
(item_code VARCHAR2(30)
,item_description VARCHAR2(80)
);
My .ctl file is:
LOAD D...
Hello,
I need to get such difference in months. Example: if date1 is 2003.10.01 and date2 is 2003.10.01 i need to get difference 1.
And if date1 is 2003.07.01 and date2 is 2003.09.01 i nee...
Dear Experts,
set feedback off
set heading off
set pagesize 0
spool abc
select * from customer;
spool off
abc.lst
---------------
SQL> select * from customer;
KC ...
How can I sort tables alphabetically in schema browser left panel (I have Oracle 10g) ?
