Hi,
I would like to know how to pass result set from a remote procedure call using DB link.
The proc1 in 1st instance calls proc2 in 2nd Instance using DBLink. The seond procedure has to ...
Hi can anybody tell me haw to show elapsed time for any scripts run in SQL plus in hour, minutes and seconds
Many thanks in advance
I have installed TOAD to my pc and have all connection environment setup to the oracle db.
At point of login to the database, this is the error that I get:
OCI.DLL - The specified module cou...
I have a new installation of Oracle 11g
I just installed Apex 3.1.2 using the following command:
@apexins apex apex temp /i/ I checked the log:
Upgrade completed successfully no errors enco...
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-...
I've recently installed Oracle Forms 6i.
I create a new form, with a control block and one button.
In the when-button-pressed trigger I put
declare
v1 varchar2(20);
begin
v1:...
Hi Experts..I am encountering a problem while trying to Highlight the record with any specific color.
My requirement is When new form is opened, the record that are satisfying the conditions ...
I want to insert SYSDATE in to a DATE field when ever there is an insert or update, can some one tell me the best method to do that
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...
Hi
i am trying to develop a simple form. in developer 6.0, in such a way
that when a user opens it, the data already entere for some specific date is diaplyed in front of him. So that he m...
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...
Hi
Hopefully this is the correct area for this question- was not sure if it should come under UNIX or Oracle.
Been struggling all morning with this and wondered if anyone could help. Ba...
I have been given access to a remote Oracle server that I need to connect to. I have never used Oracle, and don't have access to the Oracle Client, but I downloaded the Oracle SQL Developer, a...
I am trying to use ERWin to create table for ORACLE, but I am not sure how to add comment for all column, I mean I hope all Logical column name is treated as comment for that column, does anyo...
I'm trying to set up a 'development' user that can see all tables/views/etc in the production database, but at the same time I'm trying to limit the privileges granted to this user. The way I...
I have the following code in my FORM. I keep getting an ERROR 103 , pointing to the EXECUTE IMMEDIATE command each time i do a compile. I am using ORACLE 8.17 and FORMS 6i
THIS IS THE CODE:...
I want change system.record_status from new to query bucause I keep ger can not insert record here error when I try to populate a query result set to block tabulate.
Thanks for any help.
...
I am writing an ADO database application to query an Oracle table (Oracle 7.3 on windows). As the user selects a record I will lock the record using the following SQL code.
select name_co...
I am using TOAD to connect to an Oracle 8.5 instance. TOAD has been working like a charm, until a few days ago when I must have been pressing on a button somewhere by mistake, and now in the S...
We are using .bat to use Toad for conneting Oracle Database.
We need to add another entry in TNSnames.ora for new DB. Please help me to find the tnsname.ora file in the network which is use...
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...
I am currently doing an Oracle assignement & have create the following script...
Prompt To view Salesman's Sales details enter a valid Salesman ID
Prompt For example: 7499, 7521, 7654, 784...
Hello, I'm using Oracle 7.34 for this. I want to just inform the user when a certain kind of UPDATE occured in Oracle. They will be making the changes in Access forms so I figured by callin...
Dear(s),
I want to call a report by changing it whole query at runtime, please help me in this regard.
Thanks a lot.
Tanveer
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...
