Database

DECLARE @TEMP VARCHAR(7) = 
    (SELECT TOP 1 CustCode
        FROM Customer
        WHERE LEFT(CustCode, 3) = @Code)

Maximum stored procedure, function, trigger, or view nesting level exceeded (limit 32).

Hi

Need to know how to connect to Oracle (11g) database from Log4net.config (using appenders) file. As I need to wright the logs to the Oracle (11g) database when any user logon to the web application.

Note: I am succesfully able to wright the logs to the text files but not able to wright the logs to the Oracle (11g) database.

Any help is greatly appreciated.

Regards

Bala

<id><site><period-end-date><param-n><param-n+1><param-n+2>............etc.

Master Table
<id><site><period-end-date><KPI-group-A-ID><KPI-Group-B-ID><KPI-Group-C-ID>

KPI Group A Table
<id><param-n><param-n+1><param-n+2>............etc.

KPI Group B Table
<id><param-n><param-n+1><param-n+2>............etc.

KPI Group C Table
<id><param-n><param-n+1><param-n+2>............etc.

Msg 139, Level 15, State 1, Procedure Language_Update, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 2, Procedure Language_Update, Line 9
Must declare the scalar variable "@param".

/****** Object:  StoredProcedure [dbo].[Language_Update]    Script Date: 04/23/2012 11:39:57 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[Language_Update] 

(@LanguageId SmallInt , @Language NVarChar(50))
AS
BEGIN
declare @param nvarchar(1000)= N'update [Common].[Language] set '
if @Language is not NULL
BEGIN
set @param = @param + '[Language]=''' + @Language + ''',' 
End
set @param= substring(@param,0,len(@param))
set @param = @param + ' Where LanguageId=''' + cast( @LanguageId as nvarchar(5)) + ''' ' 
exec sp_executesql @param
END
GO

take attention that the script is about 77000 line and i have about 200 of this type error.<br />
<br />
Please Help !