Function plsql

CREATE OR REPLACE FUNCTION my_schema.my_function(param1 IN number) RETURN output1 IS
    cnumber NUMBER;
BEGIN
    cnumber := 2;
    RETURN (cnumber * param1);
EXCEPTION
    WHEN OTHERS THEN
        raise_application_error(-20001, 'An error was encountered - '
            || sqlcode || ' -ERROR- ' || sqlerrm);
END;

Similar codes

0 vote332 views1 answer
Generate sequence number in sql server
SQL
2 votes363 views1 answer
Get first n letter of department name in sql
SQL
10 votes381 views3 answers
Join multiple tables sql
SQL
0 vote380 views1 answer
How to delete duplicate rows in oracle
SQL
0 vote364 views2 answers
Sql server select first day of previous year
SQL
0 vote355 views1 answer
Oracle sql procedure return value
SQL
0 vote375 views1 answer
Grant privileges of databse to user
SQL
0 vote373 views1 answer
Declarative base sqlalchemy
SQL
0 vote343 views1 answer
Replace sqlalchemy
SQL
1 vote371 views1 answer
Woocommerce mysql price table
SQL