SQL & PL/SQL :: Data Insert Fails From Web Form To Database?

Mar 24, 2011

I have a pl/sql package called advisory_form. It has 3 procs. First one asks for the term it calls another web form to get it then asks for student id. Post id to second procedure and web form shows students course information with a cursor also three empty items. When advisor fills this items for each course the data should be inserted into a table.I try to do this with a loop but it didn't work properly. The data which I get from cursor is inserted properyl but when it comes to filled text boxes and select list it does not work. Some data is lost. I am adding screenshot of my web form and the data inserted to table and of course my package code.

This is what I want to insert.

CREATE OR REPLACE package body advisory_form is

countc number;
pidm number;

procedure p_sel_tid(term in term.term_code%type default null) is

hold_term varchar2(30);
begin
if not tmain.F_Vuser(pidm) then return;
end if;

if term is null then

hold_term := tmain.f_getp(pidm, 'term');
else
tmain.p_setp(pidm, 'term', term);
hold_term := term;
end if;

if hold_term is null then

bmain.p_fsterm(calling_proc_name => 'advisory_form.p_sel_tid');
return;
end if;
tmain.P_Open('advisory_form.p_sel_tid');
tmain.P_Disp('advisory_form.p_sel_tid');

[code].....

View 1 Replies


ADVERTISEMENT

Data Guard :: Broker Connecting To Standby Database Fails?

Jun 4, 2013

I checked lots of pages but I'm not able to find a solution für my problem. I already set up a primary and a standby database (prim = ALPHA1 / standby = ALPHA2). After enabling my dgmgrl configuration I got two errors:

DGM-17016: failed to retrieve status for database "alpha2"
ORA-16664: unable to receive the result from a database

The dg log from ALPHA1 says:

06/04/2013 16:06:57
Site alpha2 returned ORA-16664.
Data Guard Broker Status Summary:
Type Name Severity Status
Configuration alphadgb Warning ORA-16607
Primary Database alpha1 Success ORA-00000
Physical Standby Database alpha2 Error ORA-16664

While the dg log from ALPHA2 (standby) says:

06/04/2013 16:43:28
SPFILE is missing value for property 'LogArchiveFormat' with sid='ALPHA2'
Warning: Property 'LogArchiveFormat' has inconsistent values:METADATA='arch_ALPHA2_%S_%t_%r.arc', SPFILE='(missing)', DATABASE='arch_ALPHA2_%S_%t_%r.arc'
Failed to connect to remote database alpha1. Error is ORA-12514
Failed to send message to site alpha1. Error code is ORA-12514.

How can I solve this issue? Every type of tnsping is successfull. The sqlplus login from the primary to the standby database works, the other way round works too! Therefore the tnsnames and listener data seems to be correct.

My configuration for ALPHA1 (primary db):
---------------------------------------------------------------
Listener
---------------------------------------------------------------
LISTENER_ALPHA1 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =

[code]....

View 3 Replies View Related

SQL & PL/SQL :: DELETE Fails When INSERT In Progress?

Jan 20, 2012

I have a large 10G database, with records being inserted almost constantly. In order to "UPDATE" records, I need to be able to DELETE the old record and INSERT the new record (even while records are being inserted into the table). It appears that DELETES won't work while records are being inserted (1.5 million records per day). Is there a way around this (which I'm assuming at this point is a contention issue)? The INSERT uses the NOPARALLEL hint; no hints on the DELETE.

View 7 Replies View Related

Application Express :: How To Make Form With Report And Insert Form In Same Page

Dec 14, 2012

how to make a form with report and an insert form in the same page, these two forms are related to the same table. Our customer wants a user can add new row to the table in a form and see all of rows created by this user in a report, this report should provide edit link as well. the problem is: whenever I inserted a new row or edit a row or delete a row, and submitted, and return to this page, all of hidden items lost their values, so report is blank, and some display only items also lost their values.

View 6 Replies View Related

SQL & PL/SQL :: INSERT Data Into Database

Nov 22, 2011

I have a question how to do this.

I'm using JAVA class. I'm try to put "data" to database(INSERT data to database - PL/SQL).

I have simple JDBC problem:

Steps.
1) SELECT table_seq.NEXTVAL FROM DUAL;
(Question: How can I make sequence to table ? I see lot of examples on google but all is just to create sequence but not for table. Maybe sequence can be put on table ?)

2) INSERT table_seq.....

3) INSERT table (values) values ('data')

Tables look like this:

table1 [Where I need to take `id`]
------------
id .....
------------

table2 [Where I need this sequence to be taken]
------------
seq_id .....
------------

table2 [Where I need to put `seq_id` into table2.id and data]
------------
id data
------------

I don't get it why can't I just do this ?:
INSERT table2 (data) values ("this is data");

View 6 Replies View Related

Data Insert In Database

Jul 12, 2013

I have a database rac with two nodes. While inserting a row in the database, I am getting the following error: Error starting at line 1 in command:

INSERT INTO DocMeta(dID,xComments,xExternalDataSet,xIdcProfile,xPartitionId,xWebFlag,xStorageRule,xCpdIsTemplateEnabled,.........,xPageID,xNDDate) VALUES(7897,'','','WebStyle','','','default',0,.........,'',null)

Error report:SQL Error: ORA-29875: failed in the execution of the ODCIINDEXINSERT routineORA-20000: Oracle Text error:DRG-50857: oracle error in textindexmethods.ODCIIndexInsertORA-00604:

error occurred at recursive SQL level 1ORA-01950: no privileges on tablespace 'SYSAUX'ORA-06512: at "CTXSYS.DRUE", line 160ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 75129875. 00000 -  "failed in the execution of the ODCIINDEXINSERT routine"*Cause:   

Failed to successfully execute the ODCIIndexInsert routine.*Action:   Check to see if the routine has been coded correctly. If I try inserting in the nodes individually, sometimes it gets inserted in one node. The other node gives above error. And at times, both nodes give the same error.

View 0 Replies View Related

Registration Of 11.2 Database Fails Against 12.1 CRS

Jul 9, 2013

I am not able to register the database with 12cR1 CRS . Gettting the error as follows,  

bash-3.2$ /opt/oracle/product/11.2.0/db3/bin/srvctl add database -d   11gr2tstdb  -o /opt/oracle/product/11.2.0/db3PRCR-1006 : Failed to add resource ora.nishtest.db for nishtestPRCD-1184 : Failed to upgrade configuration of database type to version 11.2.0.3.0PRCR-1071 : Failed to register or update resource type ora.database.typeCRS-0245:  User doesn't have enough privilege to perform the operation

View 6 Replies View Related

Database Creation With DBCA Fails With Error?

Apr 8, 2013

While Creating database on AIX Machine using DBCA utility I am getting following error

Error Details:
-------------------------------------------------------------------------------------------------------------------
Allocating device....
Specifying datafiles...
Specifing datafiles...
Restoring ...

[code]....

View 2 Replies View Related

Forms :: Insert DATA In Database In Uppercase Format

Mar 19, 2013

I have a datablock based , I used commit_form(); to insert data in my DB .But,I want to insert data into my DB on uppercase format!!

View 3 Replies View Related

Replication :: Refresh Fails On MV With CLOB Data Type

May 4, 2011

Some materialized views get status broken on refreshment, but only sometime. When I try to refresh them manually I get following message:

"ORA-01400: cannot insert NULL into...".

But I know for sure that there are no NULL values in the master table, MV and master tables are declared in the same way and all columns in master tables are NOT NULL columns. Another ting is that this error I get only on columns with data type CLOB.

View 1 Replies View Related

Data Guard :: Switchover From Physical Standby To Primary Fails

May 9, 2010

i have a db's in maximum protection mode and i am trying to perform a switchover of physical standby database to primary role. but it failed., the steps followed is as follows. everything is fine with old primary site and the it is now in mounted state. When I went through the log file, I got the error message as "ORA-16072: a minimum of one standby database destination is required".the standby_archive_dest is as follows.

old primary database

SQL> alter system switch logfile;
SQL> alter system archive log current;

old standby database...Disconnect the managed recovery mode in Standby database.

SQL> recover managed standby database cancel;
Media recovery complete.
SQL> recover standby database;
AUTO
SQL> exit
[code]....

View 1 Replies View Related

Server Utilities :: How To Create Control File To Insert Data In Our Database

Dec 21, 2011

how to create control file and how to load the data through command window in our database using sql * loader.i am having structure in my database and .csv file in my desktop.

View 20 Replies View Related

Real Application Clusters :: Convert 10g Single Instance (uses ASM) Database To RAC - Reconfigure Fails?

Oct 5, 2012

I have 11gR2 GI installed on two nodes. I am trying to convert a 10g single instance (uses ASM) database to RAC and getting this error. I am trying using 12c as well as manually by using rconfig.

[main] [21:19:15:145] [ASMInstance.initialize:135] First record =[Ljava.lang.String;@958bb8
java.lang.NullPointerException
at oracle.sysman.assistants.rconfig.engine.ASMInstance.initialize(ASMInstance.java:153)
at oracle.sysman.assistants.rconfig.engine.Step.execute(Step.java:283)

[code]...

View 1 Replies View Related

Server Utilities :: Insert Data Without Writing Insert Statement In Oracle?

May 15, 2010

how to insert data in oracle table without writing insert statement in oracle 9i or above. i am not going to write insert all, merge, sqlloder and import data.

View 2 Replies View Related

Forms :: When Insert Detail The Data Insert Twice Time

Feb 27, 2012

when i tried to insert the details from oracle froms..the data inserts twice to the DB..

my table structure:

create table app_sri
(a_id integer primary key,
p_first_name varchar2(30),
p_last_name varchar2(20),
p_age number(3)
);

here a_id can be genarated through simple sequence(pid_seq)...
trigger on app_sri
create or replace trigger pid_trg

[Code]....

form insertion code..

Begin
insert into app_sri(null,'robo','Big',100);
commit
End;

the data inserted...but twice

what is the reason behind the double insertion?

View 8 Replies View Related

Forms :: Material Form With Master Items - Insert And Update

Apr 4, 2012

i have (ship_master-ship_detail) receive material form.when open the form all the master items appears except receiver name and receiver id. when i select the receiver name and id thru lov...all the items (with send information)in ship_detail also comes up expect rec_qty.i put the rec_qty and save from.

now i want to insert(ship_detail) information in another table apart from ship_detail table. if that particular matrial already exist in table it shud only update receive quantity column with +. if i am receiving the material first time then it should just insert a record with ship_detail items.

so where should i write the insert and update.

View 1 Replies View Related

SQL & PL/SQL :: How To Insert Data In Multiple Bases Using Multiple Database Links

Jan 2, 2013

how to insert the data in multiple bases( Same table structure in different bases) using the multiple database links?

View 4 Replies View Related

PL/SQL :: Create Trigger To Insert Data From One User To Another User In Same Database?

Apr 16, 2013

I Created One Trigger as Follows

CREATE OR REPLACE TRIGGER TRIGGER1
BEFORE INSERT
ON table1
FOR EACH ROW

[code]......

Here , I Want To Insert The Data From My User To Test User . In This Situation When I Execute The Above Trigger It Shows The Error PL/SQL: ORA-00942: table or view does not exist

View 3 Replies View Related

Forms :: First Form Clear Previous Data And Then Populate Data From Table

May 7, 2012

when i press when button pressed trigger, i want first the form will delete all the previous data and then populate the data from the table, that's why i used clear_block first, but this clear_code is not working here. my coding is given below

go_block('show');
clear_block(NO_VALIDATE);
declare
cursor c1 is select *
from qtr_demand order by 1;
begin
[code]..........

View 26 Replies View Related

Retrieve Info From Multiple Databases / Insert Into Central Database Via Database LINKS

Jun 10, 2013

I am trying to retrieve info from multiple DBs and insert into a central DB via DB LINKS.The links are retrieved via a cursor.

However I keep coming up against 'PL/SQL: ORA-00942: table or view does not exist'..how to handle db_links using a cursor in a pl/sql block? The code is as follows:

DECLARE
db_link_rec VARCHAR2(30);
CURSOR db_link_cur IS
SELECT DB_LINK
from MESSAGING_PROD_LIST;
BEGIN
OPEN db_link_cur;
LOOP
FETCH db_link_cur INTO db_link_rec;
EXIT when db_link_cur%NOTFOUND;
[code]....

View 1 Replies View Related

Application Express :: Insert Into History Table When Update Action Is Performed On Tabular Form View Or Table

Aug 24, 2013

My scenario is I need to insert into History table when a record is been updated into a tabular form(insert the updated record along with the additional columns Action_by,Action_type(Like Update or delete) and Action Date Into History table i.e History table contains all the records as the main table which is been visible in tabular form along with these additional columns ...Action_by,action_type and action_date.

So now i dont want to create a befor/after update trigger on base table rather i would like to create a generic procedure which will insert the updated record into history table taking the page alias and pade ID as the parameters(GENERIC procedure is nothing but whcih applies to all the tabular forms(Tables) contained int he application ).

View 2 Replies View Related

Data Warehouse - How To Insert / Access Data In The Tables

May 30, 2011

I created a data warehouse in oracle 10g n with three Dimension and one cube after that it crates 4 tables . How to use an insert sql statement to insert data in those tables n how to access them.

View 7 Replies View Related

Forms :: Cannot Commit Form When New Instance Form With Form Status Is NEW

Apr 17, 2012

I cann't commit form when new instance form with form status is "NEW".

And then i call:
Text_Item := WebUtil_File.File_Selection_Dialog('', '', 'Excel 2003|*.xls|Excel 2010|*.xlsx|All File|*.*', 'Select a file to Import', Open_File, True);
Form status change to "QUERY"

And then i click button "Import Data" from excel file to Data Block. Now form status change to "CHANGED". But i cannot call "Commit_Form" built-in to insert data to database oracle 10g.

View 9 Replies View Related

How To Connect D2k Form To Database

Jun 8, 2011

How can i connect my d2k form to database, when i installed d2k it gave an error like :

user1.pin(20):os_error while spawning ifsrv660-install forms60 server port=9000
mode=socket batch=yes

after installation when i want to compile my form it gave tns error like:
ora-12154:tns:could not resolve service name

View 3 Replies View Related

SQL & PL/SQL :: Get A Error While Adding Data Through Form

Oct 12, 2010

I get a error while adding data thru form...

Error no ORA-04098 ( trigger name is invalid and failed re-validation)

i CREATED TRIGGER ON THAT TABLE

Trigger Code is :
CREATE OR REPLACE TRIGGER TEST0_TRG
after insert on TEST0 REFERENCING
NEW AS NEW OLD AS OLD FOR EACH ROW
BEGIN
[code]......

View 4 Replies View Related

SQL & PL/SQL :: Revoke Fails Even With SYS?

May 17, 2010

I want to revoke some privileges (given from user, say A, on table TABLE to user B) with SYS, and i've got an error : It says that I can't revoke a privilege that I didn't give.

In DBA_TAB_PRIVS, there's no information about that : I can't know who gives the privilege (when I try to perform the REVOKE statment with OWNER, GRANTOR, I've got the same error).

View 20 Replies View Related

How To Insert Values In Database

Dec 10, 2006

i want to create database. i have created the schema & done all activity like decide foreign & primary key of table all things on paper? when i open oracle 8i & what should i write at front of sql prompt. For enter the value into database should i give the set path? How to store value into particular directory or folder in hard disk? should i directly start with create database?

I know proper syntax. Suppose i want to store the database & values in folder " D:apurva " what should i do. After entering oracle 8i it show sql> so what i do to store database in D:apurva . should i directly start with create table command in front of sql>

View 1 Replies View Related

SQL & PL/SQL :: How To Insert Database Function Value

Dec 19, 2011

I have following procedure

CREATE OR REPLACE PROCEDURE peter."GET_RANDOMDATE"
AS
V_CNTR number(5);
V_PKDATE VARCHAR2(20);
BEGIN

[code].....

My objective is to insert the random date value returned by datamask.get_random_date database function into peter.date_ random table.

I need the exact syntax to compile this procedure.

View 3 Replies View Related

Forms :: Insert Into Database

Jul 21, 2010

I have a form and 2 blocks(master-detail) and try to add a new record when I press "insert record" button from toolbar. But there occurs a problem. If I don't write 'CLEAR_FORM' just after calling "button_proc" procedure, record is not added into database.I couldn't understand why.

View 8 Replies View Related

SQL & PL/SQL :: How To Insert PDF Into Oracle Database

Mar 8, 2013

how can i insert .pdf file into my oracle database.

insert statement how can i insert this pdf file into my oracle database using insert statement.

View 24 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved