Skip to Main Content
Forums

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Not able to correctly plug PDB on Server

Sunil K.Jul 6 2015 — edited Jul 7 2015

I am Using

Oracle 12c 12.1.0.2.0

SQL Developer 4.1.1.19 BUILD MAIN 19.59

When I plug a Pluggable Database (from other system) to my oracle server I am not able to see any procedure or package definition on sql worksheet. althought when i right click on procedure name  and click "Quick DDL > Save to WorkSheet" I get create script of the procedure.

Is this a issue or i am missing something ??
This post has been answered by Sunil K. on Jul 7 2015
Jump to Answer

Comments

Jani Rautiainen-Oracle

I think the main issue you have is the SFTP connection. AFAIK only HTTPS connections are allowed. The documentation states:

Remote invocations with a transport protocol other than HTTPS (including plain text HTTP).

Not applicable.

does the 3rd party provide a web service to obtain the data ?

--

Jani Rautiainen

Fusion Applications Developer Relations

https://blogs.oracle.com/fadevrel/

Vasanth Gokul

Hi ,

3rd party doesn't have any web-service in place.

I heard ICS supports most of the 3rd party integration. But looks like they are not yet released. Hence trying to find some feasible options through JCS.

Since JCS (SAAS Extension) supports java based applications, can we use some 3rd party libraries in JCS to connect with SFTP through Java application ?

Appreciate your help.

Thanks,

Vasanth

Jani Rautiainen-Oracle

I am not sure; the documentation is fairly clear that only HTTPS is allowed. That said the JCS console does have some SFTP configurations listed so maybe there is some functionality, unfortunately I have no knowledge of this and have to leave it up to guys from JCS to confirm. AFAIK the SFTP details on the console are used for JDeveloper DB Cart functionality to move DM & data between systems..

--

Jani Rautiainen

Fusion Applications Developer Relations

https://blogs.oracle.com/fadevrel/

Vasanth Gokul

Hi Jani ,

Thanks for your reply.

Instead of JCS SAAS, can i use plain JCS to connect the third party system through SFTP. If so , is there any documentation or examples available on the available approached for using SFTP in JCS ? 

And also need your help to know , if not here, which is the right forum to ask our technical queries on JCS? 

Appreciate your help!

Thanks,

Vasanth

Unfortunately I am also only developer using JCS-SaaS so I cannot give definite answers on "plain JCS" as I do not have an instance to test with so I am limited to the documentation. This is the right forum to ask questions on JCS, I think there was a public holiday in US yesterday so hopefully the JCS guys will give definitive answers soon. I did forward the thread to the JCS product manager.

--

Jani Rautiainen

Fusion Applications Developer Relations

https://blogs.oracle.com/fadevrel/

1 person found this helpful
Vasanth Gokul

Any updates or inputs on the JCS part. Appreciate your help.

Thanks,

Vasanth

1 - 6
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Aug 4 2015
Added on Jul 6 2015
#sql-developer
14 comments
251 views