Question

How to specify output parameter size in stored procedure definition?

Rating8.6Very Good

I am writing the following stored procedure in oracle, that has one input parameter & one output parameter, how can i specify the size of output parameter. It is giving syntax error.

procedure sample(InParam in varchar2(10), OutParam out varchar2(10) )
as
..........
begin
..........
exception
..........
end  sample;

  1. A varchar2 field changed to datatype clob, ho…
    Currently I have a table call "testtable" and in that table is a column call "text". The text column was previously defined as a varchar2 which has the max of 4,000 chars. I have a function in a stored procedure call cr_get_test which retrieves what's in column "text" based on the incoming program and id. The re…
  2. LONG VARCHAR2 COMPARISONS
    I have a query where I am trying to compare some long VARCHAR2 strings of up to 128. Using the equals sign is very slow for obvious reaons, but does oracle have any alternate functions or index's that could possible speed this up? I am going against about 200,000 records.
  3. ORACLE STORE PROCEDURE PROBLEM
    HI: What it is the problem with this STORE PROCEDURE, I need send the parameter pID_DESEMBOLSO_FUENTE_FINAN, and if: a) pID_DESEMBOLSO_FUENTE_FINAN = 0 ; must return ALL THE ROWS IN THE TABLE b) pID_DESEMBOLSO_FUENTE_FINAN IS NULL; must return ALL THE ROWS IN THE TABLE c) pID_DESEMBOLSO…
  4. phisical size for a varchar2
    I need to know the physical size of a varchar2 field. for example. if a have a field NAME VARCHAR2(40) , how the oracle will store the data ? how many bytes this field will have ? NAME = 'FPINHEIRO' = ? BYTES NAME = '' = ? BYTES
  5. stored procedure do not give any output nor any …
    When I try to run following anoymous block, it works fine and give results but when i try to replace it with stored procedure, i don't get any error nor,I get any output when executed.Please advise --Below is procedure which does not give me any result or error when i try to execute it- create or replace procedure add_partition as declare v…

Solution

Sign up now to view this solution! It's quick, easy, and secure to subscribe. We will return you to this solution, unlocked, when you’re done.

About this Solution
View This Solution - Start Your 30 Day Free Trial
Zone
General
Tags
size oracle output parameter
Participating Experts
4
Solution Grade
A

Replies

 
by:

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 
by: DanRollins

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 
by: modulo

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 
by: anand_2000v

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

Stay Connected

Oracle Around the Web

The latest Oracle news, tips, and tricks

Oracle Unveils Netra SPARC T3 Servers

New Carrier-Grade Blade and Rackmount Servers Deliver Better Performance, Density and Power Efficiency for the Communications Industry ...

read more

Oracle fixes 21 flaws in Java SE, Java for Business

Oracle is fixing 21 flaws in its Java SE and Java for Business products in its February critical patch update issued this week ...

read more

Obama’s Silicon Valley “Tech Supper”

Why was he there? Who wasn’t invited and why? What did they talk about? Why was he really there? These are the questions being debated ...

read more

Featured Oracle Experts

slightwv

slightwv has answered more than 2,000 Oracle questions and oversees database management within the U.S. Government. Slightwv

sdstuber

A regular presenter at the Collaborate conference, Oracle developer sdstuber is a top expert in PL/SQL and Oracle 9, 10 and 11. sdstuber

Testimonials

What users are saying about our experts

"The Oracle gurus provide answers, solutions and valuable workarounds"

User: schwertner

"Wow! Excellent, valuable explanation. Hats off to you"

User: aseshu70

"Solution worked fantastic and performs excellent! Thanks heaps"

User: klausbrandlhuber

Top Experts

  1. slightwv

    2,000

    0 points yesterday

    Profile

BrowseBecome an Expert