Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.
COURSE of the MONTH
8 days, 13 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
how to do a connection inside plsql?
Posted on 2013-11-27
Is there a way to connect to oracle from plsql?
Anything available new oracle 11g new features.
Anything available new oracle 11g new features.
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
5
3-
3
- +1
15 Comments
Active today
if you are using pl/sql then you are already inside the oracle db
if you want to connect to another db, setup a db_link and use that db_link from the pl/sql
some more detail explanation may help to understand what you're looking for
if you want to connect to another db, setup a db_link and use that db_link from the pl/sql
some more detail explanation may help to understand what you're looking for
from plsql to oracle connecting ?????
read it this way --> Only after you connect to oracle database, you can use pl/sql right.
Can you please explain as to what is your requirement as it is difficult to understand from what had posted here.
read it this way --> Only after you connect to oracle database, you can use pl/sql right.
Can you please explain as to what is your requirement as it is difficult to understand from what had posted here.
Active today
>>Anything available new oracle 11g new features.
A ton of new features. This is why Oracle has a New Features Guide for every release. The online docs for your specific version has it.
A ton of new features. This is why Oracle has a New Features Guide for every release. The online docs for your specific version has it.
hmmm.. why you want to connect to another db without using db links ? The whole purpose of having db links is to give that feature right. You do not need to login to another database from one database, all you need to do is to just use the db link to query the required data from the target database by running the query from the source database itself.
connect command is not a pl/sql command to be used in the pl/sql programs. If it is using sql or unix shell scripts, then use the exit command to first logout from the current database, then again use the connect command to the target database with the username/password accordingly.
Thanks,
connect command is not a pl/sql command to be used in the pl/sql programs. If it is using sql or unix shell scripts, then use the exit command to first logout from the current database, then again use the connect command to the target database with the username/password accordingly.
Thanks,
Active today
there is no other way ...
unless you would use the host environment
technically with pl/sql you can (if you have the priviliges) create scripts on the host server
and have the database execute them
1 such sample is sending mails with attachments
> sending a mail is also contacting another database (outlook), but this has been embedded in a package, so it's not all that difficult any more
but what's the point ?
unless you want to achieve something malicious ?
please explain what exactly you want to do
unless you would use the host environment
technically with pl/sql you can (if you have the priviliges) create scripts on the host server
and have the database execute them
1 such sample is sending mails with attachments
> sending a mail is also contacting another database (outlook), but this has been embedded in a package, so it's not all that difficult any more
but what's the point ?
unless you want to achieve something malicious ?
please explain what exactly you want to do
Active today
If I am able to do that, I can easily debug plsql code in other environments.
I cannot create DBlink here.
I cannot create DBlink here.
Active today
if you can't create a dblink
and can't use the host environment or don't have access to it
then the answer to your first question is:
No, It's not possible
and can't use the host environment or don't have access to it
then the answer to your first question is:
No, It's not possible
Active today
>>I can easily debug plsql code in other environments.
How do you see being able to connect to a remote database from inside pl/sql in a local database being able to assist you in being able to debug pl/sql code in the remote database?
How do you see being able to connect to a remote database from inside pl/sql in a local database being able to assist you in being able to debug pl/sql code in the remote database?
Active today
I've requested that this question be deleted for the following reason:
No answers / impossible in oracle to do this.
No answers / impossible in oracle to do this.
Active today
a response "It's not possible" is a valid answer.
so you'll have to examine the comments and accept accordingly
so you'll have to examine the comments and accept accordingly
Active today
I agree with the above post.
Please review:
The experts told me “you can’t do that”. What do I do now?
http://support.experts-exchange.com/customer/portal/articles/755964-the-experts-told-me-%E2%80%9Cyou-can%E2%80%99t-do-that%E2%80%9D-what-do-i-do-now-?b_id=44
Please review:
The experts told me “you can’t do that”. What do I do now?
http://support.experts-exchange.com/customer/portal/articles/755964-the-experts-told-me-%E2%80%9Cyou-can%E2%80%99t-do-that%E2%80%9D-what-do-i-do-now-?b_id=44
Featured Post
Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Cursors in Oracle:
A cursor is used to process individual rows returned by database system for a query.
In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
Background
In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Suggested Courses
Course of the Month8 days, 13 hours left to enroll
765 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.