Aman Gupta

Greenhorn
+ Follow
since Nov 12, 2008
Cows and Likes
Cows
Total received
0
In last 30 days
0
Total given
0
Likes
Total received
0
Received in last 30 days
0
Total given
0
Given in last 30 days
0
Forums and Threads
Scavenger Hunt
expand Ranch Hand Scavenger Hunt
expand Greenhorn Scavenger Hunt

Recent posts by Aman Gupta

Hi,

Can you please provide me some reference material for setting up Replication Group in Oracle.
Would prefer if it also contains step by step procedure to setup along with examples.

In my current replication setup, I'm using Materialized views for replicating from Source to Staging schema.
I want to setup replication group for these Materialized views.

Please Help.

Thanks.
Thanks Joanne.

Do you also think it can be an envoirnment issue.
I'm usind JDK 1.5 with WSAD 5.1.1
13 years ago
Hi,

I'm getting the following error in WSAD 5.1.1.

Please help to reolve it -

Exception in thread "8768" java.lang.ExceptionInInitializerError
at com.tcs.ncs.rpc.RptReportManager.createRecordNew(RptReportManager.java:4545)
at com.tcs.ncs.bln.bln_ExtSvcObj.createRecordNew(bln_ExtSvcObj.java:450)
at com.tcs.ncs.bln.BillingManager.adviseForBrwr(BillingManager.java:2841)
at com.tcs.ncs.bln.BillingManager.createAccuntEntries(BillingManager.java:2325)
at com.tcs.ncs.bln.BillingManager.createBLN(BillingManager.java:2378)
at com.tcs.ncs.bln.BillingManager.netBilling(BillingManager.java:1748)
at com.tcs.ncs.bln.BFBillingNetting.process(BFBillingNetting.java:430)
at com.tcs.ncs.bln.BFBillingNetting.shell(BFBillingNetting.java:251)
at com.tcs.mastercraft.mcbatch.MCBatchPgm.callBatchFunction(MCBatchPgm.java:876)
at com.tcs.mastercraft.mcbatch.MCBatchPgm.exec(MCBatchPgm.java:259)
at com.tcs.ncs.bln.BPBillingNetting.start(BPBillingNetting.java:47)
at com.tcs.ncs.bln.BPBillingNetting_Controller.run(BPBillingNetting_Controller.java:347)
at java.lang.Thread.run(Thread.java:595)
Caused by: java.lang.NullPointerException
at java.text.SimpleDateFormat.compile(SimpleDateFormat.java:584)
at java.text.SimpleDateFormat.initialize(SimpleDateFormat.java:497)
at java.text.SimpleDateFormat.<init>(SimpleDateFormat.java:446)
at java.text.SimpleDateFormat.<init>(SimpleDateFormat.java:427)
at com.tcs.ncs.util.StringConverter.<init>(StringConverter.java:39)
at com.tcs.ncs.util.LocalizationHelper.<clinit>(LocalizationHelper.java:67)
... 13 more
13 years ago
Hi,

I have 2 databases on different machines - ORCL on 172.21.161.107 and scmb10g on 172.21.161.60.
I tried to create a database link from ORCL on 172.21.161.107 to scmb10g on 172.21.161.60.
The public db link is created successfully....but while trying to access it, I'm getting foll error .

Please Help.



SQL> create public database link fsnew10 connect to onsitedba identified by onsitedba using '(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 172.21.161.60)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = SCMB10g) ) )';

Database link created.

SQL> commit;

Commit complete.

SQL> select * from SYG_SYSTEM_GLOBALS@fsnew10;
select * from SYG_SYSTEM_GLOBALS@fsnew10
*
ERROR at line 1:
ORA-12541: TNS:no listener
Hi,

I have 2 databases on different machines - ORCL on 172.21.161.107 and scmb10g on 172.21.161.60.
I tried to create a database link from ORCL on 172.21.161.107 to scmb10g on 172.21.161.60.
The public db link is created successfully....but while trying to access it, I'm getting foll error .

Please Help.



SQL> create public database link fsnew10 connect to onsitedba identified by onsitedba using '(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 172.21.161.60)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = SCMB10g) ) )';

Database link created.

SQL> commit;

Commit complete.

SQL> select * from SYG_SYSTEM_GLOBALS@fsnew10;
select * from SYG_SYSTEM_GLOBALS@fsnew10
*
ERROR at line 1:
ORA-12541: TNS:no listener
Hi,
I have a requirement of a trigger which will trim the value of column CAA_NAME as soon as this column is updated.
I hv written the foll trigger to achieve the same.

But after the trigger is configured and i try to update caa_name column, I'm getting -

ora-04091: table caa_ca is mutating,trigger-function may not see it
ora-06512: at "TRIMCAACC4_MAIN", line 2
ora-04088: error during execution of trigger


Please Help.



CREATE OR REPLACE TRIGGER TRIMCAACC4_MAIN
AFTER UPDATE OF
CAA_NAME
ON
CAA_CA
REFERENCING NEW AS NEW
FOR EACH ROW
BEGIN
UPDATE CAA_CA SET
CAA_NAME = TRIM(:NEW.CAA_NAME)
WHERE CAA_CA_ID=:NEW.CAA_CA_ID ;

END;
Hi,
I have a requirement of a trigger which will trim the value of column CAA_NAME as soon as this column is updated.
I hv written the foll trigger to achieve the same.

But after the trigger is configured and i try to update caa_name column, I'm getting -

ora-04091: table caa_ca is mutating,trigger-function may not see it
ora-06512: at "TRIMCAACC4_MAIN", line 2
ora-04088: error during execution of trigger


Please Help.



CREATE OR REPLACE TRIGGER TRIMCAACC4_MAIN
AFTER UPDATE OF
CAA_NAME
ON
CAA_CA
REFERENCING NEW AS NEW
FOR EACH ROW
BEGIN
UPDATE CAA_CA SET
CAA_NAME = TRIM(:NEW.CAA_NAME)
WHERE CAA_CA_ID=:NEW.CAA_CA_ID ;

END;
Thanks Amit.I have updated the details.
Hi

I did not create any SQL trigger or procedure before. What I need is that I have 6 tables as:
1- Parent1 [Employee]: EmpID (PK), EmpName ...etc.
2- Child1 [EmpCourse]: EmpID (FK), CourseName, ...etc
3- Child2 [EmpExperience]: EmpID (FK), ExperienceSource, ...etc.

4- CopyofParent1 [Employee]: EmpID (PK), EmpName ...etc.
5- CopyofChild1 [EmpCourse]: EmpID (FK), CourseName, ...etc
6- CopyofChild2 [EmpExperience]: EmpID (FK), ExperienceSource, ...etc.


CopyofParent1 columns is superset of Parent1 columns.
Similarly for CopyofChild1 and CopyofChild2.

As soon as a record in Parent1 is inserted and meets a certain criterion, the record shd be inserted in CopyofParent1 using EmpID .
At this time, records from Child1 and Child2 for the same Parent shd be inserted in CopyofChild1 and CopyofChild2 resp.


Please help.

Thanks
Hi

I did not create any SQL trigger or procedure before. What I need is that I have 6 tables as:
1- Parent1 [Employee]: EmpID (PK), EmpName ...etc.
2- Child1 [EmpCourse]: EmpID (FK), CourseName, ...etc
3- Child2 [EmpExperience]: EmpID (FK), ExperienceSource, ...etc.

4- CopyofParent1 [Employee]: EmpID (PK), EmpName ...etc.
5- CopyofChild1 [EmpCourse]: EmpID (FK), CourseName, ...etc
6- CopyofChild2 [EmpExperience]: EmpID (FK), ExperienceSource, ...etc.


CopyofParent1 columns is superset of Parent1 columns.
Similarly for CopyofChild1 and CopyofChild2.

As soon as a record in Parent1 is inserted and meets a certain criterion, the record shd be inserted in CopyofParent1 using EmpID .
At this time, records from Child1 and Child2 for the same Parent shd be inserted in CopyofChild1 and CopyofChild2 resp.


Please help.

Thanks