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 (...
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...
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 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...
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 ...
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...
I need to read excel file using PL/SQL, please provide step by step procedure.
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...
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 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...
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...
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 ...
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,
is it possible convert a unix time stamp 1151530818 into oracle date format jan-22-1987
I currently have Quest Toad for Oracle 9.0.1.8 installed on my PC. I have the "Save Passwords" open enabled which saves the schema/password and database name for all connections I make. Ther...
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...
Hi,
I need to export my toad software to a new laptop. I have many database connections and passwords saved on my old laptop (many of them which i do not remember now) which i want to export ...
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...
Now I've read the action to take:
Cause: The given library is attached to the form but cannot be located in the search path for PL/SQL libraries.
Action: Make sure that the given librar...
Hi all,
Is there anywhere I can download just the imp/exp tools ? I have 9i client installed, but need the tools to export some data using a script.
Quick answers will be appreciated, a...
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...
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...
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
Below is my XML, I need to read this xml using PL/SQL which is stored in oracle database as a clob object. I need to find out the attributes for the tags for example <workordertype>?
<?xml...
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
(
...
