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

23 votes352 views1 answer
How remove column in mysql
SQL
2 votes376 views6 answers
Mysql change timezone
SQL
0 vote353 views2 answers
Collation in sql
SQL
3 votes327 views3 answers
Print in pl sql
SQL
0 vote366 views1 answer
Oracle array
SQL
3 votes343 views3 answers
Django.db.utils.OperationalError: no such table:
SQL
0 vote373 views1 answer
How to write if case in select query in select statement
SQL
1 vote352 views1 answer
Table infromation in sql server
SQL
7 votes340 views3 answers
Postgre describe table
SQL
0 vote340 views1 answer
Sql change date format
SQL