Ok, well, since you didn’t show any code, I’ll make a few assumptions here.
Based on the ORA-1461 error, it seems that you’ve specified a LONG datatype in a select statement? And you’re trying to bind it to an output variable? Is that right? The error is pretty straight forward. You can only bind a LONG value for insert into LONG column.
Not sure what else to say. The error is fairly self-explanatory.
In general, it’s a good idea to move away from LONG datatype to a CLOB. CLOBs are much better supported, and LONG datatypes really are only there for backward compatibility.
Here’s a list of LONG datatype restrictions
Hope that helps.
Related Posts:
- How can I convert MP3 file to a Base64 encoded string? [closed]
- How is the AND/OR operator represented as in Regular Expressions?
- TCP vs UDP – What is a TCP connection? [duplicate]
- did you specify the right host or port? error on Kubernetes
- What is archive mode in rsync?
- 403 Forbidden vs 401 Unauthorized HTTP responses
- Turn off pager for psql’s interactive output
- How do I get my C# program to sleep for 50 msec?
- How can I sort a dictionary by key?
- How to align iframe always in the center
- How to turn IDENTITY_INSERT on and off using SQL Server 2008?sql-server-2008
- XPath contains(text(),’some string’) doesn’t work when used with node with more than one Text subnode
- Error in .External.graphics R
- Time Complexity of Prims Algorithm?
- Does != have meaning in OCaml?
- Assembly’s manifest definition does not match assembly reference
- Java – No enclosing instance of type Foo is accessible
- How does createOrReplaceTempView work in Spark?
- “package XXX is not in GOROOT” when building a Go project
- what is the difference between OLE DB and ODBC data sources?
- How do I get a list of built-in data sets in R?
- How to terminate the script in JavaScript?
- Manually create a pyspark dataframe
- Git push won’t do anything (everything up-to-date)
- spring @sqlgroup with multiple datasource
- Spyder does not autocomplete local variables
- What is the definition of a “disparity map”?
- Git error on git pull (unable to update local ref)
- git status shows modifications, git checkout —
doesn’t remove them - Tool for drawing parse trees?
- Resource interpreted as stylesheet but transferred with MIME type text/html (seems not related with web server)
- how to uninstall MinGW and make cygwin ‘make’ as deafult make program with gcc 3.8.1
- Clearing localStorage in javascript?
- “docker build” requires exactly 1 argument(s)
- How to get the selected item from a ComboBox in JavaFX?
- Downcasting in Java
- How do I get monitor resolution in Python?
- How do I get monitor resolution in Python?
- What is O(1) space complexity?
- SonarQube Runner vs Scanner
- How to set the authorization header using cURL
- R error which says “Models were not all fitted to the same size of dataset”
- Error in glm() in R
- OCaml: Match expression inside another one?
- Create new tmux session from inside a tmux session
- Swift protocols: method does not override any method from its superclass
- Disable Chrome pinch zoom for use in kiosk
- jQuery onclick not firing on dynamically inserted HTML elements?
- JavaScript: IIF like statement
- What is the relationship between PyTorch and Torch?
- Receiving “message”:”CB-ACCESS-KEY header is required” when attempting to connect to coinbase pro api
- How to implement OnFragmentInteractionListener
- What is the `data-target` attribute in Bootstrap 3?
- simple IPython example raises exception on sys.exit()
- PostgreSQL: Query has no destination for result data
- if-not condition fails (jQuery)
- RGBA code for red color
- Arithmetic Overflow in mips
- error: unknown type name ‘bool’
- How to draw lines in Java
- NoClassDefFoundError in Java: com/google/common/base/Function
- While running the script throws cannot find module ‘dotenv’
- Brackets : how to make autocomplete / autoindent works ?
- Python: What OS am I running on?
- Import error No module named skimage
- In Java, what is a shallow copy?
- Why define PI = 4*ATAN(1.d0)
- Android marshmallow : Galaxy Note 4 Screen Overlay Detected
- Passing a hexadecimal value into a module in Verilog
- Visual Studio 2019 – error MSB8020: The build tools for Visual Studio 2013 cannot be found
- mport win32ui in python 3.6
- How to print a int64_t type in C
- textarea’s rows, and cols attribute in CSS
- Set size of WordPress thumbnail post
- Contact Form 7 – Execute code AFTER mail send [closed]
- wp_localize_script with mce_external_plugins in wordpress
- Forbid contributors viewing drafts
- Contact Form 7: Redirecting on a condition? [closed]
- show taxonomy meta field in template
- Multiple og:image for Facebook
- Simple JS function Not Working
- Password protected Profile View
- Reset counter with jQuery [closed]
- What are the obstacles to providing reliable Internet access and Wi-Fi at large tech conferences? [closed]
- Symlink not updating as expected when using an absolute with relative path
- What are the different widely used RAID levels and when should I consider them?
- What is a glue record?
- Why is DNS failover not recommended?
- Is it possible to generate RSA key without pass phrase?
- Getting “Cannot ioctl TUNSETIFF tun: Operation not permitted” when trying to connect to OpenVPN
- Run Oracle SQL script and exit from sqlplus.exe via command prompt
- Find the location of a systemd unit file service
- Windows Server restart / shutdown history
- Cooling Server Closet – No A/C Is Possible
- nmap find all alive hostnames and IPs in LAN
- How to filter http traffic in Wireshark?
- How to inspect remote SMTP server’s TLS certificate?
- Dealing with HTTP w00tw00t attacks
- Do SPF Records For Primary Domain apply to subdomains?
- Why is the response on localhost so slow?