Hi
I'm trying to write a report that has an outer join to a constant. I have the following SQL:
SELECT .......
FROM ........
WHERE ext_trad_ref.cmpy_num(+) = trade.cmpy_num
...
Hi,
I want to import my database design to a "visual model".
I don't have ERWIN, do you know a freeware or open source that I can use?
I just want to import my model to a "visual model"...
Hi,
First I got the ORA-01578 data block corrupted on file #3, block #4159 error message. Then, I found out that corruption is on the rollback segment RB3. I took the RB3 offline. I trie...
i am using toad to develop pl/sql
there is a way to check values in ys_refcursor during debug??
where is the registry UI_ICON and how do i set it up
I am using TOAD 8.6.1 to connect to an oracle database. I have already done a tnsping and everything came back ok. But when i try to connect to this particular schema i get 'ORA-12571: TNS:p...
We want to run ASP page to display some records w/ picture (BLOB) from Oracle 10g database. And just found some sample coding, that is worked for picuter display. But when I change it somethin...
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?
Oracle Discoverer 9i EUL5_Documents table - Need to capture Workbook SQL stored in Long Raw data type
We are using Oracle 11i eBusiness Suite with Oracle 10G Discoverer AS and are currently...
Hi there,
Our IT group just upgraded to 10g (from 9i). Previously, I'd been using the Direct Connect method in TOAD for data analysis to connect to our Oracle database. With the upgra...
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 ...
How can I call a PL/SQL procedure from a UNIX script?
And it can be done at a scheduled time?
Can I send a file using FTP from a PL/SQL procedure?, if not how can I do it with a UNIX script...
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...
I have table test(a varchar2(9));
The values are of the form
26-00-000
26-01-001
26-01-002
26-02-001
26-02-002
26-02-003
26-01-003
You can understand it as level wise:
26-00...
Hi there,
we run an Oracle database version 10g which we want to back-up with the (Veritas) Symantec back-up exec Oracle agent.
The Oracle database has an SID of 10 characters, the probl...
Hi there,
I am looking for the Hyperion System 9 Security Guide. This should be a PDF that is availiable to download.
Any help will be greatly appreciated.
Thanks !
I have 3 different ref cursors which stores data for 3 different years. The ref cursors have 4 columns of
Dept,Manager,Emp Name ,Salary(of each year).
I need to form a 2 dimensional array...
Hi experts,
I installed the WebUtil package provided from oracle.
What I did is:
declare
v_filename varchar2(100);
in_file Client_Text_IO.FILE_TYPE;
Begin
v_filename := 'C:\GRF\cds....
I had to modify a database table by adding a few fields. There existed an Oracle Forms data block based on the table before the changes had been made. Can I refresh the block so that it reco...
I am developing a student enrolment system. There is a master table for basic info. The table name is STUDENT. Then I have a table SDETAIL(subject,timing,credits, ... etc) for each individual ...
I am trying to test a stored procedure which is used by a Crystal Report in Toad to make sure I can get data outside of Crystal. When I try to execute my code, Toad wants me to initialize the ...
I have a stored procedure which returns a PL/SQL table of records.
I need to understand how I can access this table return using Perl DBI/DBD and Oracle 8.1.7.
I use the following statemen...
Hi there,
I'm running a vb application which connect to Oracle via ODBC.
I get this error message when it running my SQL statement, which is only a select statement... [Oracle][ODBC]Invali...
Hello experts
I want to display a horizontal scroll bar in th detail block which has 8 fields in tabular format with 10 records and dont' know how to. Please advise.
How can I add a scrollbar to a window. I've been able to add scrollbars to data blocks. But I do have a form with 3 datablocks, and vertical space is not enough. Thanks indeed.
Julian