PL/SQL: ORA-00947: not enough values error message
Hi all i am getting Error(25,63): PL/SQL: ORA-00947: not enough values error message when executing

cyrillic string conversion question
Hello,

First time here...

I would like to know if there is a way to convert a

Random date selection
i want to select random date with time(hour+minutes+sec) where date is specified(10/22/2009) and tim

Problem Dereferencing
With these types and tables:

CREATE TYPE MANAGER AS OBJECT (
MGR_ID INTEGER,

am I using this for loop correctly
Dear buddies!

Right now I am generating a report with some details for all the dealers.

Need help with basic sql
Hi,

I am using oracle 10g, and having some small doubts related to sql , here goes the si

Cursor statement failed with errors
Following statement failed with the errors.

cursor proj_cursor1 is (select projectID from

Revoking alter any table from a schema
Hi All,

i am working in Oracle 10g.
my requirement is to revoke all kind of DDL oper

Consuming third party Payment Gateway API from Procedure.
Hi All,

First of all i would like to thank all the people of the oracle forum for providi

query help
Hi experts.

i have a table rep2 like this
PROD_COD ACCT_NO DUE_DAYS BALANCE

Execure stored procedure on a timer
Can someone tell me an easier way to execute a stored procedure on a timer? I am using Oracle 10g R

Casting Decimals in Oracle
This code worked as a query in DB2, but I am not sure what the syntax is for casting decimals in Ora

how to populate a drop down box
Hi buddies!

PROCEDURE DOWNLOAD_REPORT_FORM (report_name varchar) is begin DOWNLO

SQL query not working well
Hi,
I made a small table with 5 rows and want to make them an sql consult using rownum

Data storage spaces in varchar2
Trying to understand what's happening.
I am selecting a value from a table that is defined as c

Find current logon time
Hi,
in my sql script i want to query and find out the logon time of the current session.
<

Escape Latin Characters
I need to escape latin characters in an xml doc. Example: "é" is escaped to "é". I thoug

please help me in this update statment
hi every one

if I have table and this data in it

id name
10

Hashing?
Hi, I was hoping to take a string value then convert it - consistently - across each of our pages in

Results from Db outputted twice
Hey guys.. for come reason my data is outputted twise shown in the image below and i cant figure out