How to execute an oracle stored procedure?

Execute is sql*plus syntax .. try wrapping your call in begin .. end like this:

begin 
    temp_proc;
end;

(Although Jeffrey says this doesn’t work in APEX .. but you’re trying to get this to run in SQLDeveloper .. try the ‘Run’ menu there.)

Related Posts:

  1. ORA-29913: error in executing ODCIEXTTABLEOPEN callout when inserting csv into oracle
  2. SQL error “ORA-01722: invalid number”
  3. ORA-00984: column not allowed here [duplicate]
  4. How to resolve ORA 00936 Missing Expression Error?
  5. PLS-00201 – identifier must be declared
  6. SQL error “ORA-01722: invalid number”
  7. PLS-00103: Encountered the symbol when expecting one of the following:
  8. UTL_FILE.FOPEN() procedure not accepting path for directory?
  9. ORA-01861: literal does not match format string
  10. Is there a combination of “LIKE” and “IN” in SQL?
  11. How to insert date values into table
  12. What is the Oracle equivalent of SQL Server’s IsNull() function?
  13. ORA-01747: invalid user.table.column, table.column, or column specification
  14. ORA-06502: PL/SQL: numeric or value error: character string buffer too small
  15. Query to display all tablespaces in a database and datafiles
  16. How do I use CREATE OR REPLACE?
  17. ORA-01779: cannot modify a column which maps to a non key-preserved table
  18. ora-06553 pls-306 wrong number or types of arguments in call to ‘ogc_x’
  19. Run Oracle SQL script and exit from sqlplus.exe via command prompt
  20. Visual List of iOS Fonts?
  21. How to get rid of the “No bootable medium found!” error in Virtual Box? [closed]
  22. ‘git’ is not recognized as an internal or external command
  23. error: ORA-65096: invalid common user or role name in oracle
  24. How can I write a `try`/`except` block that catches all exceptions?
  25. How do I decompile a .dll file?
  26. What’s the purpose of git-mv?
  27. How to write trycatch in R
  28. how to use proxy on youtube-dl?
  29. SSH -X “Warning: untrusted X11 forwarding setup failed: xauth key data not generated”
  30. LINQ equivalent of foreach for IEnumerable
  31. Can a foreign key be NULL and/or duplicate?
  32. How to do vlookup and fill down (like in Excel) in R?
  33. Using “super” in C++
  34. What is the difference between application server and web server?
  35. Were jprobes removed from kernel v4?
  36. ldap_sasl_bind(SIMPLE): Can’t contact LDAP server(-1)
  37. ORA-00918: column ambiguously defined in SELECT *
  38. PHP – Failed to open stream : No such file or directory
  39. How to extract the substring between two markers?
  40. Code-first vs Model/Database-first
  41. How to resolve git’s “not something we can merge” error
  42. CSS Box Shadow Bottom Only
  43. How to squash all git commits into one?
  44. how to fix Javac invalid flag error?
  45. PHP & MySQL: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given
  46. “Insert if not exists” statement in SQLite
  47. Web API Error – This request has been blocked; the content must be served over HTTPS
  48. How do I time a method’s execution in Java?
  49. -bash: export: `=’: not a valid identifier
  50. Unable to convert 3d ply file image to 2d image
  51. Get a random item from a JavaScript array
  52. Plotting horizontal and vertical lines in Mathematica
  53. Error while waiting for device: Time out after 300seconds waiting for emulator to come online
  54. How to transparent Unity3D custom shader?
  55. Converting string to integer VB.NET
  56. Is it valid to have a html form inside another html form?
  57. what is shortcut command to kill process in windows command?
  58. Differentiate between function overloading and function overriding
  59. java.sql.SQLException: Fail to convert to internal representation
  60. Representing EOF in C code?
  61. DATEDIFF function in Oracle
  62. How to disable an Android button?
  63. How to set initial value and auto increment in MySQL?
  64. Apache Kafka vs Apache Storm
  65. How can an Admin access the Google Drive contents of all the users in a particular domain?
  66. PSEXEC, access denied errors
  67. How do you define a global function in C++?
  68. A _disk_id.pod file appears on a windows flash drive
  69. What standard do language codes of the form “zh-Hans” belong to?
  70. What is the proof of of (N–1) + (N–2) + (N–3) + … + 1= N*(N–1)/2 
  71. Merge posts plugin? [closed]
  72. How to See Everything in get_option()?
  73. How can I prevent the WordPress Importer from munging double-newline paragraph breaks to a single newline?
  74. Slow WP Site, theme.php not caching? Up to 25 second load time! [closed]
  75. How to hide subfolder of static pages in WordPress using htaccess
  76. Javascript: Add anchor hashtag to URL, and reload
  77. How do I deal with a compromised server?
  78. Something is burning in the server room; how can I quickly identify what it is?
  79. Finding out what user Apache is running as?
  80. Do systemd unit files have to be reloaded when modified?
  81. What is a glue record?
  82. How do I convert a .cer certificate to .pem?
  83. Show full process name in top
  84. How do you do load testing and capacity planning for web sites?
  85. What is a good SSH server to use on Windows? [closed]
  86. In systemd, what’s the difference between After= and Requires=?
  87. Windows Server restart / shutdown history
  88. How do I set the global PATH environment variable on OS X?
  89. nmap find all alive hostnames and IPs in LAN
  90. Should CNAME Be Used For Subdomains?
  91. How do I create user accounts from the Terminal in Mac OS X 10.5?
  92. How to get a .pem file from ssh key pair?
  93. How to inspect remote SMTP server’s TLS certificate?
  94. Choosing between meaningful and meaningless hostnames [closed]
  95. logrotating files in a directories and its subdirectories
  96. Multiple TXT fields for same subdomain
  97. How to restart Nginx on Mac OS X?
  98. Do SPF Records For Primary Domain apply to subdomains?
  99. Why is the response on localhost so slow?
  100. apache2: Could not reliably determine the server’s fully qualified domain name, using 127.0.1.1 for ServerName

Leave a Comment

tech