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 vote212 views1 answer
Jpa generationtype sequence mysql
SQL
0 vote212 views1 answer
Should I use the datetime or timestamp data type in MySQL?
SQL
0 vote212 views1 answer
Mysql case when on date
SQL
12 votes159 views1 answer
Env var for setting password for root user mysql docker hub
SQL
0 vote180 views1 answer
Null column as zero in mysql
SQL
2 votes169 views2 answers
How to create an empty table from an existing table
SQL
0 vote183 views1 answer
How to get nth number in sql
SQL
0 vote175 views1 answer
Convert rows into columns in oracle
SQL
0 vote175 views1 answer
Running query in redshift
SQL
1 vote175 views1 answer
Set autoincrement to 0
SQL