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]

Taidot: Oracle, SQL, Tietokannan hallinto, Tietokantakehitys, MySQL

Näytä lisää: 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

Tietoa työnantajasta:
( 12 arvostelua ) Santa Clara, United States

Projektin tunnus: #28383126

9 freelanceria on tarjonnut keskimäärin $112 tähän työhön


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

$120 USD 2 päivässä
(26 arvostelua)

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 Lisää

$90 USD 3 päivässä
(12 arvostelua)

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 Lisää

$250 USD 5 päivässä
(4 arvostelua)

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 Lisää

$120 USD 3 päivässä
(3 arvostelua)

♦ 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 Lisää

$150 USD 1 päivässä
(1 arvostelu)

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_ Lisää

$100 USD 2 päivässä
(3 arvostelua)

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 1 päivässä
(4 arvostelua)

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 7 päivässä
(1 arvostelu)

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

$100 USD 1 päivässä
(0 arvostelua)