Discussions
Categories
- 197K All Categories
- 2.5K Data
- 546 Big Data Appliance
- 1.9K Data Science
- 450.8K Databases
- 221.9K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 552 MySQL Community Space
- 479 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3.1K ORDS, SODA & JSON in the Database
- 556 SQLcl
- 4K SQL Developer Data Modeler
- 187.2K SQL & PL/SQL
- 21.4K SQL Developer
- 296.4K Development
- 17 Developer Projects
- 139 Programming Languages
- 293.1K Development Tools
- 111 DevOps
- 3.1K QA/Testing
- 646.1K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 161 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.2K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 19 Java Essentials
- 162 Java 8 Questions
- 86K Java Programming
- 81 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 205 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 475 LiveLabs
- 39 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 175 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 233 Portuguese
How to enter binds in Oracle PL/SQL for VS Code?

Recently started using the Oracle PL/SQL extension for VS Code. To execute the querry I use Ctrl+R and the result is displayed. But in this particular querry I have to input the binds. Unlike Toad for oracle or Oracle SQL Developer, VS Code does not let me enter binds and since it does not let me enter the binds, it gives me the following error
ORA-01008: not all variables bound
How can I rectify this small problem? How can I input my binds in VS Code?
A small part of the querry I wanted to run is shown below.
SELECT ces.event_seq_num, 1 causality_exists FROM case_event_assess ces WHERE ces.case_id = :case_id AND ces.prod_seq_num = :dummy1 AND ces.license_id = 0 AND ces.datasheet_id = 0 AND ( ces.rpt_causality_id IS NOT NULL OR ces.det_causality_id IS NOT NULL OR ces.PRT_causality_id IS NOT NULL)
Best Answer
-
Have you tried using the VAR or DEF SQL*Plus commands?
Please try it out:
https://www.oracle.com/database/technologies/appdev/dotnet/odtvscodesqlplus.html
Answers
-
Have you tried using the VAR or DEF SQL*Plus commands?
Please try it out:
https://www.oracle.com/database/technologies/appdev/dotnet/odtvscodesqlplus.html
-
@Christian.Shay -Oracle Will try, Thanks!
-
The default substitution variable prefix is an ampersand (&). use below command to change the substitution variable prefix to (:)
SET DEFINE :
-
This should be fixed in 21.4.0.