Hi
I cant seem to find the solution to this, can anybody please tell me if there is a switch I can turn on to log all sql statements from Oracle Toad 9 to a text file?
The reason I want ...
I'm using Oracle 8i Enterprise Edition.
I tried to import Datawarehousing sample schema
in Oracle8i.
It returned with an error saying
"BITMAP INDEX FEATURE NOT ENABLED".
In the Oracle ...
I have two Oracle databases, basically identical, that I need to be able to migrate data to and from. The migration has to be of the dynamic, on-the-fly variety. For the most part, I'm able ...
Hi,
I have 2 Questions.
A] How to preocess an array in PL/SQL ?
B] How to declare an Implicit Cursor ? I am using Oracle 8.1.7
Whenever u declare a cursor using Declare Cursor...
Hi experts!
I am trying to run a database schema comparison from command line. I have database connection and everything set ok.
However when running the script, TOAD starts and present...
We have many client machines (oracle developer 6i installed which has Oracle 8i client) suddenly stopping connections to the database (Oracle 9i). tnsnames.ora is fine, because it used to conn...
How Do I use a cursor that return of a PL/SQL FUnction, into a SQL Stament? . I have Oracle 8i.
We have an application currently running Oracle Forms 6i. On the Client-Server application we use TEXT_IO and its procedures and functions to output data (from the screens and dB) to MSWord. ...
Hello,
I am doing a project at uni which involving building a prototype data warehouse. For the last two weeks, I was supposed to research the oracle warehouse builder application. Its become...
Hi there,
I don't know what is happen to my form, i thought maybe my form was corrupted by UFO (unknown form object). I able to open and compile but failed to open canvas and run that form...
i'm running toad v 7.5.0.0. i log in to oracle using one schema, then want to view triggers owned by another schema. when i try to do this, i can't see any triggers. at first i thought my log...
I haven't worked before with web services and oracle. Is it possible to invoke a web service from a pl/sql trigger of a table, sending data from that table? What should i do? I work with Oracl...
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)
...
It's probably the easiest question on this site but I just can't seem to find a solution (and I only have 210 points!!) :
How can I issue multiple commands to Oracle without having to execu...
I have a report that looks like this
Item Serial number Descr Date Type
all the fields except date come from o...
Hi I'm still trying to accomplish this feat. I've left off just trying to see if the row existed in the ST_Max table once I did my displays I found that I did have the fetched the same data bu...
Is there a reverse engineer program for a .fmx file to .fmb on another site?
Can one tell me how i can display content of clob column on oracle form develper?
My form give a fault (FRM-41003).can you help me to solve this problem?
(p_username IN dba_role_privs.grantee%TYPE,
p_role OUT dba_role_privs.granted_role%TYPE) IS
v_username dba_role_privs.grantee%TYPE;
v_role dba_role_privs.granted_role%TYPE;
BEGIN
SELECT...
Is there a way to export few tables into separated delimited files using Toad using a single script? I do not want to use the export data in toad as i would have to export a few times dependin...
Hi ,
I'm writing a package in which i have info into PL/SQL table. Based on the PL/SQL table i need to retrieve data using another SQL.
I can use stored function to get the element fr...
I have two forms: FORM1 does a call_form to FORM2.
What i want to do is to pass a value called V1 that was calculated in FORM1 over to FORM2.
HOW DO I PASS VALUES BETWEEN FORMS?
We are very new to Oracle forms. We have several tabbed forms. We're trying to present only certain tabs on each one, based on a query of a user security table. We've gotten as far as to eff...
please send me
best code of form button..like save and modify
