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

3 votes242 views2 answers
Enter mysql command line
SQL
0 vote184 views1 answer
C# mysql update statement set value to null
SQL
0 vote189 views1 answer
How to get inserted id in sql server
SQL
0 vote205 views1 answer
Access mysql database docker container shell
SQL
0 vote195 views1 answer
Mysql date only no time
SQL
0 vote211 views1 answer
How to change mysql port in xampp
SQL
1 vote191 views1 answer
How to get the date diff on once field in sql server
SQL
0 vote223 views2 answers
Postgres having
SQL
0 vote188 views1 answer
Mysql earlier than date
SQL
0 vote178 views1 answer
Ms sql database data size
SQL