#!/usr/bin/perl
open(FOO,">c:/prod_test.sql");
$create = "Create or replace procedure ";
$body = "\nbegin\n null;\n";
$statement = $create."foo(";
for ($x=0;$x<8188;$x++){
$statement .= "a$x in varchar2,\n ";
}
$statement .= "done in varchar2)\n as";
print FOO $statement.$body."end;";
close FOO;
at 8187 parameters it compiled. at 8188 it gave a program to large error. its tested body length by adding "null;" to the body 10,000 times and it didn't mind. One other thing is the 2499 character limit per line.
Getting Below Power BI Report connection error during execution . Error: Something went wrong Unable to connect to the data source undefined. Please try again later or contact support. If you contact support, please provide these details. Underlying error code: -2147467259 Table: Business Sector. Underlying error message: AnalysisServices: A connection cannot be made. Ensure that the server is running. DM_ErrorDetailNameCode_UnderlyingHResult: -2147467259 Microsoft.Data.Mashup.ValueError.DataSourceKind: AnalysisServices Microsoft.Data.Mashup.ValueError.DataSourcePath: 10.10.10.60;T_CustomerMaster_ST Microsoft.Data.Mashup.ValueError.Reason: DataSource.Error Cluster URI: WABI-WEST-EUROPE-redirect.analysis.windows.net Activity ID: c72c4f12-8c27-475f-b576-a539dd81826a Request ID: dfb54166-c78f-4b40-779f-e8922a6687ad Time: 2019-09-26 10:03:29Z Solution: We found report connection not able to connect to SQL Analysis service so tried below option. ...