| bhmadhukar |
Posted: Feb 08, 2008 04:04:21 AM |
Total Post: 14
Joined: Jan, 2008
|
i wrote a function known as inputmaxno(maxno number).
what my question is, if i pass a number like below to the function like;
select inputmaxno(23) from dual;
out/put: ok 23.
if i pass a string say 'abc' as a parameter like;
select inputmaxno('abc') from dual;
ORACLE is throwing "Invalid Number" - an error.
But, i want the function inputmaxno(maxno number) should throw an error...
how is it?
plz tell me
in adv. thanks
|
|
|
 priya |
| Posted: Feb 08, 2008 05:31:45 AM |  |
|
Total Post: 39
Joined: Apr, 2007
|
the parameter is declared as number. so it ll accept only the number..
|
|
|
|
|
| Mohammed Taj |
| Posted: Feb 09, 2008 12:08:01 AM | |
|
Total Post: 746
Joined: Jul, 2007
|
>>>But, i want the function inputmaxno(maxno number) should throw an error...
????
|
|
|
|
|
| mohamed riaz |
| Posted: Feb 13, 2008 01:30:51 AM | |
|
Total Post: 95
Joined: Sep, 2006
|
Dear all,
can any one help me i have
table names : wss_act,prod_map
relation key : product_type
how will you write a plsql select into statement to join these 2 tables?
pls reply soon
regards
RIAZ
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
