I have two schema that I use: one for development and one that's used
for live data.
I'm currently working on a large project so I have extensive updates to
the development schema and various databases within it. In most cases

I am trying to call the portal.wwsec_api from within an apex
application. The application is parsed using the portal schema so has
all the correct grants by default.
The code I am using is:

Hi Gurus,
I am looking for a stored procedure or package to find total number of
rows in each table in a schema.
Something like, you can pass the schema name ot the SP or may be simple

ASGI, recognized as one of the Inc 500 Fastest Growing Privately held
companies in the USA, has been a valuable partner with premier IT
Implementation companies for the past 7 years, providing technology
resources for various mission critical projects across Americas, UK and

I need to send an automatic mail through lotus notes
In the mail i should attach a PDF document .
MY mail is generating but im unable to attached my pdf document.
Pls give me solution how can i attach pdf document in my mail and it

i'm connected to 9.2.0.1 database.
I've tried to run explain plan but, got ora error ora-00933: SQL command not
properly ended.
plan_table is created (see script) and in menu/toad options i use

i was attempting to migrate an Access DB to Oracle 10g XE.
When i launch Oracle Migration Workbanch Repository Login he says i have not
any plugin installed.
Where i find pulgins? and how i can install them?

I'm using toad 6.3.2.1.
While querry is ran, error end-of-communication-channel occurs.
Query aiming table on  8.1.7 database through database link.
I'm connected to oracle database 9.2.0.1 through sqlnet 9.2.0.1  (Client).

I have a problem with the SQL-Loader using the expression-function. I
get the following error but I cannot find whats wrong with my
control-file.
Perhaps anyone can help me.

Hi all, I want to display Unicode chars in Toad. I have set the font
for the result grid to "@Arial Unicode MS", but trying this:
 select unistr('\0416') from dual
The letter ¿ is displayed instead of the cyrillic letter Ж.

when I want to log in to the EM I'm getting the following error:
"This OC4J is configured to make JMX connections via RMIS and fall back
to RMI if the RMIS port is not configured. The RMIS connection on the
OC4J instance home on Application Server assoa.locahost is configured

Yellowfin leads the new players in taking business intelligence
mainstream.
(Association Press) - Get ready for the next wave of business
intelligence, which will once and for all take BI mainstream, with

For about a week and a half I have been trying to solve a mysterious
issue with unique constraint violations on our database server without
any luck.
We basically have a simple table with a unique primary key (number) and

Is it possible to intercept queries on the Oracle Server prior to
processing and encompass some rules around how the queries are
processed?
For e.g. Depending on varying parameters I may want to deny users

I have a written following sql statements in the Bourne shell script.
But when I run the shell script, it takes a long time and doesn't give
out any result. I have to interrupt it by Ctrl-C or kill -9. The code
has no syntax errors and the variables like $user, $pass and $sid have