I am trying to set up Explain plan tables in Toad. When I run the Toadprep.sql script in Toad's sql editor, it comes with dialog box asking me to enter the values for,
1) :USERS
2) :INDX
...
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...
I have 3 questions.
In my application I am using ORACLE procedure with insert statement into table from select statement (INSERT INTO <TABLE_NAME>
(SELECT <huge select statement with UNIO...
Hello,
I'm working with an old product, Oracle forms developer... and users every day comlaining that they works very slow. Also, program crack down with massages dump... ect.
What could be ...
Hi all
I have a cursor that retrieves data. However when an exception occures e.g. WHEN NO DATA FOUND the script will stop or if there is a problem with the current line of data it will ...
hello expert,
I have quite a few sql
I can run same via sqlplus prompt no error reported
and they all execute okay.
when i attempt to run same sql via toad for oracle (freeware)
...
I have some *.dbf files and i want import it into oracle database.
How to do it?
Hey Guys -- Any help would be appreciated....
Need to have Dynamic Creation of SQL Statement based on parameters passed into Stored Procedure. Return type of Function needs to be Ref Curso...
Hello, I am trying to connect to an Oracle DB through TOAD, but I get the infamous ORA-12154 error message ("could not resolve service name").
From the connection string of an Interdev projec...
Hi all,
i would need a clue for the following:
I have to implement functions to check db-users for several DB`s.
So, i got some scripts to implement.
creating user.............. blablabla....
Hi,
I want to display a combo box on a form based on the field(based on a query) from the table. when the user selects a value, i call oracle reports and generate a report.
how do i do t...
Is there is any software available that make an er diagram for an existing user/schema.
I have program that give the option to make a er diagram then it converts it to a sql script file so...
Here we go again.
It has been determined to start over - bring the forms from 4.5 to 6i, and the database from 7.2.3 to 9.2.0.
Forms 6i will talk to my 9i database, however, when I try t...
I'm currently working on Oracle RAXINV invoice and making a number of modifications. The last one I need to make is to ensure that the invoice totals only print on the last page. The report as...
in our organization we are using oracle database and a software for attandance system i want to configure it on linux machine. is it possible if it is possible kindly suggest me what we need t...
Hi,
I am trying to execute the following query
select * from wsh.wsh_locations
I am getting the following error in toad
OCI-22303: type "MDSYS
I tried executing the same quer...
HELLO, ALL!
I have been troubled by an INSERT sentence that seems to be having problems ONLY when executed from an ADODB.Connection object in Visual Basic 6.
If I execute this from SQL+,...
Hi All,
I'm attempting for the first time to put together a PL/SQL script to sequentially update a field within a table... I'm working with the following:
DECLARE
/* Output variabl...
Hi,
I have created a packadge. Its specification:
"
PACKAGE GET_O_NUMBER
IS
FUNCTION F_O_NUMBER
( kodas IN number,
numeris IN varchar2 )
RETURN varchar2;
PRAG...
Hi,
I'm really hoping someone can help me with this. I have a pl/sql program that has literally hundreds of statements within a block. I have a 'WHEN OTHERS' exception handler. Within this...
Hi:
I am using Import / Export Wizard in SQL SERVER 2000.
When copying tables into SQL SERVER from Oracle database I receive the following error:
ORA-01652 Unable to extend temp segment...
pstmt = conn.prepareStatement ("select System_Identifier, System_Password,Server_Name,Type,Version,Ser_Interface_Version,Client_Identifier from TP_CALLAPPL_INFO");
The above call returns ORA-...
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 ...
Is it possible to exp database schema using lower (8.1.7) version exp from a higher version database server (9i)?
What is the easest way to move data from 9i to 8.1.7?
Thanks
g
some tips:
ok a remark is marked as --debugging
where i think the problem is
working on hpux
oracle 7
apps 10 SC
RUNNING FROM WIN XP (i dont know if this has any problem
to use ...
