Need help writing a procedure in Oracle Sql Developer

I need a procedure written that will link my two databases (without using dblink) and will be able to save data from a PL/SQL form on the second database to a table on the main database. The form and table are already done, I just need the procedure to work. It must save data from the form submissions on the new database (OPS$WORKFLOW_PRO_PUBLIC) to a table set up on the main database (OPS$WORKFLOW_PRO).


I need help linking two databases on the same instance without using a dblink. We do not have permissions for a dblink and it is unnecessary since the two databases are within the same instance. Can someone please help review my code and let me know what I am doing wrong?

Following are the neccessary tables

[login to view URL]

[login to view URL]

Kemahiran: Oracle, SQL, Pentadbiran Pangkalan Data, Pembangunan Pangkalan Data, MySQL

Lihat lagi: run stored procedure oracle sql 2005, qtp oracle sql developer, need help writing business plan days, need help writing business plan, need help writing hotel descriptions, convert mssql procedure oracle sql procedure, need help writing letter cleaning business, need help writing project plan, need help writing text website, need help writing 250 word essay grade year, oracle sql developer random number generation, need help writing sql statements, oracle sql developer perforce support, how to execute stored procedure in oracle sql developer with parameters, how to test stored procedure in oracle sql developer, how to edit stored procedure in oracle sql developer, execute procedure in oracle sql developer, oracle sql developer help center, how to debug stored procedure in oracle sql developer

Tentang Majikan:
( 12 ulasan ) Santa Clara, United States

ID Projek: #28383126

9 pekerja bebas membida secara purata $112 untuk pekerjaan ini


--- Procedure creation expert also for linking two database into same instance ---- we can discuss to start

$120 USD dalam 2 hari
(26 Ulasan)

I am expertise in writing oracle sql, pl/sql procedures, functions in different versions of oracle enterprise editions. I would like to propose an alternative without dblink, it's not possible to access database. name Lagi

$90 USD dalam 3 hari
(12 Ulasan)

Hi Hiring manager I am NodeJS, Angular, React, MongoDB, SQL Expert. MEAN Stack Ninja I'm a highly experienced and motivated Senior Software Engineer/Architect with 8+ years of experience. Top skills you may be looki Lagi

$250 USD dalam 5 hari
(4 Ulasan)

HI , Dear i am having 8+ years extensive experience in oracle / SQL / Pl SQL and i can do this within 2-3 days , i am having also having experience of oracle apps ebs so its my primary job to develop scenario like th Lagi

$120 USD dalam 3 hari
(3 Ulasan)

♦ PLSQL Expert ♦ ORACLE Expert ♦ Immediate Start ♦ I’m a software Engineer with 8+ years experience in DB development. I’m expertised in multiple databases Oracle, MSSQL, postgresql and MYSQL. I think I would be right Lagi

$150 USD dalam sehari
(1 Ulasan)

I will create the database procedure and maintain data in main and new database as you describe above. I request you to qualify tables or object you are defining or accessing in SQL queries like instance_name.database_ Lagi

$100 USD dalam 2 hari
(3 Ulasan)

hi, i play game when its Oracle database , i am OCP , i can do this job for you, inbox me for the details...

$50 USD dalam sehari
(4 Ulasan)

Kindly contact me I can review it for free I just need your recommendation Kindly contact me I have over than 12 years experience

$30 USD dalam 7 hari
(1 Ulasan)

I will create the database procedure and maintain data in main and new database as you describe above.

$100 USD dalam sehari
(0 Ulasan)