No announcements
Found 2424414 threads
-
1 Votesmust declare a scarlar value in a view
hi you can make the following trick to insert default value CREATE FUNCTION dbo.mytest ( @yrnum ...Answered | 5 Replies | 1829 Views | Created by Corlen - Wednesday, February 1, 2012 12:48 PM | Last reply by Kalman Toth - Wednesday, February 1, 2012 9:18 PM
-
3 Votes
ORA-00904 invalid identifier message after source system went through vendor upgrade process
Please see the sample below: Data Source=(DESCRIPTION=(CID=GTU_APP)(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST= ...Answered | 5 Replies | 4944 Views | Created by DaveDVF - Wednesday, October 16, 2013 3:37 PM | Last reply by DaveDVF - Friday, October 25, 2013 11:49 AM -
1 Votes
Must declare the scalar variable?
[ @statement= ] statement Is a Unicode string that contains a Transact-SQL statement or batch.Answered | 5 Replies | 8096 Views | Created by Westside2008 - Tuesday, March 6, 2012 2:56 AM | Last reply by Naomi N - Tuesday, March 6, 2012 3:36 AM -
0 Votes
ORA - 06550 error
The stored procedure compiles fine on it's own ERROR________________________________________________________________ ORA-06550: Line 1 Colum 7:PLS-00306: ...Unanswered | 2 Replies | 31 Views | Created by Anonymous - Monday, October 25, 2004 2:23 PM | Last reply by Anonymous - Monday, October 25, 2004 9:10 PM -
0 Votes
Pls help me to create the query to extract from a XML column in table
It's because of the used non-default namespace in Xml, so you have to declare it for the query DECLARE @xml AS XML = '<Policies ...Answered | 2 Replies | 519 Views | Created by Manesar - Wednesday, February 15, 2017 4:20 PM | Last reply by Olaf Helper - Thursday, February 16, 2017 7:44 AM -
0 Votes
Error Must declare the scalar variable?
Have you already declared ResourceWorkgroup as a parameter in the report?Answered | 5 Replies | 1198 Views | Created by Dave Oh - Monday, January 4, 2016 7:15 PM | Last reply by Dave Oh - Tuesday, January 5, 2016 5:08 PM -
0 Votes
Column to row, pls help me
http://jahaines.blogspot.com/2009/06/concatenating-column-values-part-1.htmlAnswered | 6 Replies | 3683 Views | Created by Grant Guan - Friday, June 11, 2010 2:18 AM | Last reply by Grant Guan - Friday, June 11, 2010 8:20 AM -
2 Votes
How to pass an array of byte arrays using ODP.Net?
I get the following exception: Oracle.DataAccess.Client.OracleException was unhandled by user code Message=ORA-06550: ...Answered | 1 Replies | 7905 Views | Created by DiligentKarma - Friday, December 2, 2011 11:36 PM | Last reply by Wang Huang - Saturday, December 3, 2011 9:20 AM -
1 Votes
Must declare the scalar variable.
Because SQL is a declarative language, we do not use local variables.Answered | 7 Replies | 27185 Views | Created by KamAbA - Thursday, October 3, 2013 11:51 AM | Last reply by Josh Ashwood - Tuesday, October 8, 2013 5:41 AM -
0 Votes
How to invoke a stored procedure from DbUpdate Activity from the Workflow Designer
Exception: System.Data.OracleClient.OracleException ORA-06550: line 1, column ...Answered | 3 Replies | 3075 Views | Created by Artapan - Wednesday, May 15, 2013 9:47 PM | Last reply by Khaled Dehia - Tuesday, May 21, 2013 6:14 PM -
0 Votes
ORA-12154: TNS:could not resolve the connect identifier specified.
To solve problem - ORA-12154: TNS:could not resolve the connect identifier specified.Answered | 12 Replies | 30243 Views | Created by Muhammad Faiq Bakhtyar - Wednesday, April 20, 2011 10:48 AM | Last reply by Sivanesan Sethuraman - Thursday, December 14, 2017 8:23 PM -
1 Votes
ADO Connection Error: ORA-12154: TNS:could not resolve the connect identifier specified
Hi All, Error Message - "ORA-12154: TNS:could not resolve the connect identifier specified" Tools: Microsoft Visual Studio 2013 ...Answered | 2 Replies | 4363 Views | Created by andrewlpchan - Thursday, February 12, 2015 9:59 AM | Last reply by andrewlpchan - Friday, February 13, 2015 12:49 PM -
0 Votes
Declaring temp table produces Msg 1087 "Must declare the table variable"
DECLARE @MaxThinning TABLE ( CID int NOT NULL, LegConditionId int NOT NULL, ...Answered | 1 Replies | 1790 Views | Created by Chris Allen - Data Architect - Tuesday, February 23, 2016 3:27 PM | Last reply by Olaf Helper - Tuesday, February 23, 2016 3:32 PM -
0 Votes
Error calling a function
It is common problem when writing PL/SQL to add a new proc but forget to declare it in the package declaration section resulting in ...Unanswered | 8 Replies | 198 Views | Created by Anonymous - Friday, July 24, 2015 6:47 AM | Last reply by Anonymous - Friday, July 24, 2015 11:38 AM -
0 Votes
Must declare the scalar variable "@ProductID".
[spx_Pager] @PageNo int = 1, @ItemsPerPage int = 2, @TotalRows int out, @ProductID int AS BEGIN SET NOCOUNT ON; DECLARE ...Answered | 4 Replies | 10400 Views | Created by Shifty001 - Saturday, February 2, 2013 2:25 PM | Last reply by Erland Sommarskog - Saturday, February 2, 2013 3:54 PM -
1 Votes
Running multiple CREATE..DROP statements in Execute SQL Task
One of the answers I got is as follows: begin execute immediate 'drop table ABC'; execute immediate 'drop table XYZ'; ...Answered | 3 Replies | 7924 Views | Created by rockstar283 - Thursday, February 9, 2012 5:49 PM | Last reply by SwapnilKothari - Friday, February 10, 2012 8:05 PM -
0 Votes
Must declare the scalar variable
@sql_conditions.Answered | 3 Replies | 18036 Views | Created by SowSanura - Tuesday, March 25, 2014 4:46 AM | Last reply by scott_morris-ga - Tuesday, March 25, 2014 1:23 PM -
0 Votes
Getting error "ORA-12154" TNS could not resolve the identifier specified"
Hello: I am getting the error "ORA-12154 - TNS could not resolve the identifier specified" when trying to connect to the Oracle database with this stored ...Answered | 1 Replies | 1909 Views | Created by programmer-in-training10 - Friday, January 3, 2014 11:41 PM | Last reply by scott_morris-ga - Monday, January 6, 2014 7:34 PM -
0 Votes
Error:- ORA-06550, VB.NET and Oracle
SiteID=1" href="http://forums.microsoft.com/MSDN/default.aspx?Answered | 1 Replies | 5984 Views | Created by srkvellanki - Friday, October 19, 2007 11:54 AM | Last reply by Gaurav Seth - Tuesday, October 23, 2007 10:33 AM -
0 Votes
ORA-06550, PLS-00306; Error inserting data to Oracle procedure.
oraCmd.Parameters["o_cust_cd"].Value : null; custInfo[1] = oraCmd.Parameters["o_person_nr"].Value !Unanswered | 5 Replies | 2209 Views | Created by Anonymous - Tuesday, September 28, 2010 3:49 PM | Last reply by Anonymous - Tuesday, September 28, 2010 5:16 PM
No announcements
