473,511 Members | 15,046 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

How to execute a function with one out parameter and 2 in parameters & out parameter?

2 New Member
how to execute a function with one out parameter and 2 in parameters & out parameter is of object type .
Feb 4 '11 #1
2 2011
rski
700 Recognized Expert Contributor
Did you try to call it by your self? If so what syntax did you use? Did you get any errors?
Feb 5 '11 #2
oracledeveloper
2 New Member
ORA-06550: line 5, column 11:
PLS-00306: wrong number or types of arguments in call to

CREATE OR REPLACE
TYPE "TL_STRING" IS TABLE OF T_STRING

CREATE OR REPLACE
TYPE "T_STRING" AS OBJECT ( STRING_DATA VARCHAR2(200));


CREATE OR REPLACE x(
y_V IN VARCHAR2, -- LIST OF VALLUES
z_V IN VARCHAR2, -- SEPARATOR (,)
k OUT TL_STRING
)
declare
k1 varchar2(200);
k varchar2(200);
begin
k1:=x('Bhanu',',',k);
dbms_output.put_Line(k||','||k1);
end;
Feb 7 '11 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

11
2434
by: Florian Loitsch | last post by:
I'm currently writing a JS->Scheme compiler (which, using Bigloo, automatically yields a JS->C, JS->JVM, JS->.NET compiler), and have a question concerning the function-parameters: According to...
5
11114
by: Roger Withnell | last post by:
I have tried using setTimeout to delay the execution of a function with: setTimeout('function()', ms) This works, but if the function has parameters: setTimeout('function(p1, p2, p3)', ms) ...
3
2069
by: Alex Munk | last post by:
I would like to be able to pass a 2-dimensional array to a function as a string parameter. In the called function I would like to be able to convert the string back into a 2-dimensional array....
2
2935
by: waitan | last post by:
#include <algorithm> #include <iostream> #include <fstream> #include <string> #include <vector> #include <sstream> #include <iterator> #include <iomanip> using namespace std;
9
2743
by: Marek Vondrak | last post by:
Hello. I have written the following program and am curious why it prints "1" "2". What are the exact effects of explicitly providing function template parameters at the call? Is the second...
0
1112
by: kike | last post by:
I want to call a javascript function WITH parameters function from c# code; I already did this: ..... StartDate.Attributes.Add("onTextChange","DateGreaterThan(" + StartDate.Value + "," +...
2
2383
by: perdubug | last post by:
Somebody told me that Tasking C166 C++ compiler has problems with temporary objects in function call parameters. He gave me below examples: Case 1:Wrong: rc = foo(&bar()); Case 2:Right: bar...
1
1238
by: monomaniac21 | last post by:
Hi all how can you pass an array to a function as a single parameter? regards Marc
1
1513
by: kenia | last post by:
Hello! I need to attach a function with parameters to an event using the DOM standard, but i can't find a way to do it. I've used the following : element.event = function; But in this case...
6
2704
by: Harry2o | last post by:
Can anyone tell me, why in the blazes GCC (e.g. 4.4.3) does not warn about or error the incorrect call of a nullary function? void hello() { } int main( int argc, char* argv ) { int test =...
0
7237
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
7137
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
7349
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
1
7074
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
5659
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
1
5063
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
4734
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
3210
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
1572
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.