Passing value to the function in sql query

Question

Consider the following situation:

SELECT TestPkg.getData(123) FROM dual;

returns correct result, but

SELECT TestPkg.getData(SELECT TO_NUMBER('123') FROM dual) FROM dual;

gives error as missing expression, why is that so? How to tackle with such situation where we are passing value to function which is dependent on value from query.

Thorsten Kettner · Accepted Answer · 2013-10-30 11:27:25Z

5

To evaluate a select result you need brackets:

SELECT TestPkg.getData( (SELECT TO_NUMBER('123') FROM dual) ) FROM dual;

One pair for the function call, one for the evaluation of the select result.

answered Oct 30, 2013 at 11:27

Thorsten Kettner

96.6k8 gold badges56 silver badges82 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Giannis Paraskevopoulos · Accepted Answer · 2013-10-30 11:26:28Z

1

I think you need:

SELECT TestPkg.getData(TO_NUMBER('123')) FROM dual;

answered Oct 30, 2013 at 11:26

Giannis Paraskevopoulos

18.5k2 gold badges52 silver badges72 bronze badges

Collectives™ on Stack Overflow

Passing value to the function in sql query

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related